Combining text and variables in a string???

  • Thread starter Thread starter bastraker via AccessMonster.com
  • Start date Start date
B

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
 
bastraker via AccessMonster.com said:
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.
Click to expand...

If I'm following you correctly perhaps...

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