spacing

[ilaria]

I want my report to have no spaces between the various fields (like name, surname). I have tried the canshrink property and I have the textboxes adjoining, but it did not work. What am I doing wrong?

 

[SteveA]

Access will not shrink fields horizontally, only vertically, and will only shrink fields vertically if there is no text at all to display on the nominated row (including labels).

If you want to have a field that shows First and Last Name together, you could try having one field with a recordsource similar to =[FirstName] & " " & [LastName].

HTH
SteveA

 

[ilaria]

Thanks a lot, that worked!