Trim Function

[ZMac]

Hello,

Hope I can explain my problem so that it makes sense.

I am having a problem creating an address block in Access 2007 report. I have a 5 field address; Name1, Name2, Address1, Address2, CityStateZip. (The fields Name2 and Address2 do not always have information for each record.)

When I create a report I am getting a blank line when there isn't information for fields Name2 and Address2. I am using the Trim function and have set the properties to each of the fields to "shrink".

This is how the address block is printing:
JOHN DOE



1234 Anywhere Ave S

City XX 12345

I want it to look like this:
JOHN DOE
1234 Anywhere Ave S
City XX 12345

This works correctly on reports I have previously created in Access 2003. I have even tried coping & pasting the fields from Access 2003 into Access 2007 but still can't get it to work.

Does my problem have anything to do with "grouping"? I can't seem to find anywhere in the report module to "group" items.

[RuralGuy]

Did you set the Detail section CanShrink property true?

[ZMac]

Yes I did. Seems very strange that it doesn't work. Like I've said, I have even tried copy/paste from a report in Access2003 that does work property into my report in Access2007 database but it doesn't "shrink" the fields that do not contain information.

[RuralGuy]

Can you post the db so we can play with it? Remove any sensitive data of course.

[ZMac]

I just tried adding the "address block" into the the report header section and that appears to have solved the problem.

[RuralGuy]

Can Shrink works *if* there is not something else on that line. Try moving the controls up above the Invoice Date stuff on the right and you will see the shrink works. You need to turn it on first.

[ZMac]

Rural Guy,

Sorry, I was editing my previous post as you were apparently responding. Moving the "address block" into the header section appears to have solved my problem. Thank you for all your help.

[RuralGuy]

I just moved them up so they were on a different line from the Date Controls on the right but still in the Detail section of the report and it works. If you're satisfied with the solution then go ahead and mark this thread as Solved.

[ZMac]

Your solution has helped me understand what the actual problem was. This will be very helpful in the future. Thanks again for all your help.

How do I mark this as solved?

[RuralGuy]

Follow the link in my signature.