Combining text and variables in a string???

[bastraker via AccessMonster.com]

Hello All

Hopefully this is an easy one. I have the following

Me.Text32.Value = DateStart
Me.Text34.Value = DateEnd

and I need to get the value of my DateActual text box to read as

BETWEEN #4/2/06# AND #4/4/06#

The dates are obviously just an example. I'm not sure of the Visual Basic
syntax to combine text and the value of DateStart and DateEnd. Is there some
sort of delimeter I need to use? Thanx in advance for any assistance.

D

 

[Rick Brandt]

Hello All

Hopefully this is an easy one. I have the following

Me.Text32.Value = DateStart
Me.Text34.Value = DateEnd

and I need to get the value of my DateActual text box to read as

BETWEEN #4/2/06# AND #4/4/06#

The dates are obviously just an example. I'm not sure of the Visual Basic
syntax to combine text and the value of DateStart and DateEnd. Is there some
sort of delimeter I need to use? Thanx in advance for any assistance.

If I'm following you correctly perhaps...

="BETWEEN #" & Me!Text32 & "# AND #" & Me!Text34 & "#"

 

[bastraker via AccessMonster.com]

That was the ticket

Thanx Rick!!