Labels: Can't format "date" when it shares line with "customer"

[Michael from St. Louis]

On the first line of my label, I have "customer" followed by date.
=Trim([Customer] & " (" & [Date] & ")")
I want to select "Date" so I can format it to m/yy. I was able to do it for
the Query from which the report is based. But I can't do it for the report
because when I click on the line, the entire line is selected instead of just
the "Date" part of the line. How can I select just the "Date" part of the
line, or else allow the format from the Query be maintained when it appears
in the report?

 

[fredg]

On the first line of my label, I have "customer" followed by date.
=Trim([Customer] & " (" & [Date] & ")")
I want to select "Date" so I can format it to m/yy. I was able to do it for
the Query from which the report is based. But I can't do it for the report
because when I click on the line, the entire line is selected instead of just
the "Date" part of the line. How can I select just the "Date" part of the
line, or else allow the format from the Query be maintained when it appears
in the report?

=Trim([Customer]) & " (" & Format([Date],"m/yy") & ")"

NOTE:
Date is a reserved Access/VBA/Jet word and should not be used as a
field name.
For additional reserved words, see the Microsoft KnowledgeBase article
for your version of Access:

109312 'Reserved Words in Microsoft Access' for Access 97
209187 'ACC2000: Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'
321266 'ACC2002: Microsoft Jet 4.0 Reserved Words'

 

[Tom Lake]

On the first line of my label, I have "customer" followed by date.
=Trim([Customer] & " (" & [Date] & ")")
I want to select "Date" so I can format it to m/yy. I was able to do it for
the Query from which the report is based. But I can't do it for the report
because when I click on the line, the entire line is selected instead of just
the "Date" part of the line. How can I select just the "Date" part of the
line, or else allow the format from the Query be maintained when it appears
in the report?

When the whole line is selected, press the right cursor key once. That
will deselect the line and allow you to move the cursor to the date part.
You can turn off the option to select the entire line in the Options choice
of the Tools menu.

Tom Lake