Expression Syntax (1 Viewer)

mrabrams2

Registered User.
Local time
Yesterday, 22:54
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
 

bjackson

Registered User.
Local time
Today, 12:54
Joined
Jan 3, 2003
Messages
404
"Accounts Received Between " & [Forms]![frmABC]![txtBeginDate] & " and " & [Forms]![frmABC]![txtEndDate]
 

mrabrams2

Registered User.
Local time
Yesterday, 22:54
Joined
Apr 29, 2003
Messages
54
&&&&&&&&&&&

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

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

Michael
 

Users who are viewing this thread

Top Bottom