Auto sizing field in a report

[meliorexi]

Hi

I am trying to develop a report that outputs customer information. Trouble is the field sizes are not changing automatically according to the size of the value, leaving large spaces between, for example, first and last name. I am aware of the 'can grow' / 'can shrink' property, however this only works with null values.

Can anyone please assist.

 

[LittleSmudge]

First off I assume you are actually talking about CONTROLS not fields

FIELDS are in TABLES
It is CONTROLS that you see on Forms and Reports.


Can Grow and Can Shrink work in the VERTICAL direction only
If controls overlap each other then the CanGrow/Can Shrink will not work properly

If you want to concatenate strings from different fields into somwthing that looks like they are joined together then you'll need an UNBound text box control and put in it's ControlSource
=[FName] & " " & [LName]

( Replace [FName] and [LName] with whatever you field names really are. )


'ope-that-'elps.



G LS
spsinkNOJUNK@yahoo.co.uk
Remove the NOJUNK to use.

 

[meliorexi]

Yes, you're right. I was talking about controls.

Many thanks for your help.