Avery Label Report Formatting

[Benny Wong]

Hello All,
I am working with Access 2000. I am working on a mailing label report. The label report works fine however, I would like the report to do the following:
Here is the current format of the label:

=Trim([FirstName] & ", " & [LastName] & " " & [Title])

1. If the FirstName and LastName don't exist then the Title will print in place of the FirstName position on the far left (left-justified) without the comma.
2. If it involves VBA, what code will I need and what event to paste it to. Thank you in advance for your help.

 

[shay]

Hi

Try putting the following in the control source of your report's text box...


=iif ((isnull[FirstName] and isnull[LastName]), [Title], Trim([FirstName] & ", " & [LastName] & " " & [Title]) )

hth

shay