Expression Syntax

mrabrams2

Registered User.
Local time
Today, 00:49
Joined
Apr 29, 2003
Messages
54
Unbound form - frmABC
Textbox - txtBeginDate
Textbox - txtEndDate

Report - rptReceived

I would like a textbox on the report's page header to read:

Accounts Received Between xx/xx/xxxx and xx/xx/xxxx

I just can't seem to get the syntax exact.

I have:
"Accounts Received Between " [Forms]![frmABC]![txtBeginDate] " and " [Forms]![frmABC]![txtEndDate]

Is it close?

Thanks for your help!
Michael
 
"Accounts Received Between " & [Forms]![frmABC]![txtBeginDate] & " and " & [Forms]![frmABC]![txtEndDate]
 
&&&&&&&&&&&

Man, I did it again.... those darn ampersands !!:o

Thank you VERY much bjackson for your help. Of course, it works wonderfully !!

Michael
 

Users who are viewing this thread

Back
Top Bottom