Text field size and Report generation 
Author Message
 Text field size and Report generation
I have a database containing three text fields. One of the fields contains
text data varying from 10 to 70 characters. If I change the field's size,
while in Layout Mode, I can see the information but it doesn't make sense
because most fields are less than 10 characters. Can I have that text field
to be sort of "self-adjusting"?

Thanks,
--
Evan Panagiotopoulos
Technology, Library and Media Director
Poughkeepsie City School District

Yes We Can, Watch Us Do It!



Tue, 19 Aug 2003 08:46:12 GMT
 Text field size and Report generation

No.  But there are few work arounds, each to suit slightly different
circumstances:

1.  Use a merge field to display the contents of the layout.  Merge
fields, unlike ordinary fields, are self adjusting.  Drawback: you cannot
edit the contents of a merge field.

2.  Format the field to show a scroll bar.  Drawback: scroll bars look
ridiculous and don't work well if only one line of the field is visible.

3.  If the reason that you only have room for one line is that you are in
a list view, you could put the field in a in the footer where it could
take up as many lines as you need and act as a "preview pane" .  When you
select a record in the list, the contents of that field for that record
will show in the preview pane.  Drawback:  fields placed the footer cannot
be edited or scrolled.

--
Bridget Eley


Quote:

> I have a database containing three text fields. One of the fields contains
> text data varying from 10 to 70 characters. If I change the field's size,
> while in Layout Mode, I can see the information but it doesn't make sense
> because most fields are less than 10 characters. Can I have that text field
> to be sort of "self-adjusting"?

> Thanks,
> --
> Evan Panagiotopoulos
> Technology, Library and Media Director
> Poughkeepsie City School District

> Yes We Can, Watch Us Do It!



Tue, 19 Aug 2003 09:16:58 GMT
 Text field size and Report generation
Evan,

I think you might be talking about Sliding fields.

Jeanne


Quote:
> I have a database containing three text fields. One of the fields contains
> text data varying from 10 to 70 characters. If I change the field's size,
> while in Layout Mode, I can see the information but it doesn't make sense
> because most fields are less than 10 characters. Can I have that text
field
> to be sort of "self-adjusting"?

> Thanks,
> --
> Evan Panagiotopoulos
> Technology, Library and Media Director
> Poughkeepsie City School District

> Yes We Can, Watch Us Do It!



Tue, 19 Aug 2003 23:05:26 GMT
 Text field size and Report generation

Quote:

> I have a database containing three text fields. One of the fields contains
> text data varying from 10 to 70 characters. If I change the field's size,
> while in Layout Mode, I can see the information but it doesn't make sense
> because most fields are less than 10 characters. Can I have that text field
> to be sort of "self-adjusting"?

In Layout mode, make the field as large as you might ever need. Then
select the field and go to Format/Sliding/printing, click 'sliding up',
'based on all above', 'Also reduce the size of the enclosing part'.

This shrinks the field to whatever is in it, and all the fields slide up
so that you don't get unsightly gaps in your printout. This only works
in Preview or Print mode. You can also make things slide left.

Remember that in sliding they don't remove any white space you have left
*between* the fields, so if you have, say ten fields with 3mm of white
space between each two, 9 empty fields sliding up will accumulate 27mm
of white space.
--
Maire Black



Wed, 20 Aug 2003 01:13:07 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. Constructing a text field in a Paradox report from database fields

2. Best way to handle variable-size text fields

3. Text field size

4. text field size

5. Varchar or Text fields and Max Row Size

6. Text field size

7. 900 size limit on text and varchar fields

8. Var Char VS Text Fields - Size Limits?

9. SQL Text Field Size Limit ?????????????

10. Size of a text field.

11. Modifying Text Field Size

12. Null Size of text field objects from SQLPASSTHROUGH=64


 
Powered by phpBB® Forum Software