Combining text and variables in a string???

's Computer Specifications

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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...dules/200604/1

's Computer Specifications

"bastraker via AccessMonster.com" <u19274@uwe> wrote in message
news:5e4b07dfb231e@uwe...
> 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 & "#"

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

's Computer Specifications

That was the ticket

Thanx Rick!!
>

--
Message posted via http://www.accessmonster.com

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Combining a string of text	tracktor	Microsoft Excel Misc	3	22nd May 2008 02:22 PM
combining text and numbers in a string	=?Utf-8?B?YWpk?=	Microsoft Excel Worksheet Functions	2	3rd Nov 2006 04:17 PM
variables in text string	=?Utf-8?B?c21rMjM=?=	Microsoft Access VBA Modules	1	26th Feb 2006 04:05 AM
Combining 2 variables	Tom Petersen	Microsoft ASP .NET	3	21st Mar 2005 07:46 PM
Using variables from two text files in the same command string	bladeraptor	Microsoft Windows 2000 CMD Promt	8	9th Feb 2004 09:31 AM