error from getting value from a text box

[eddie wang]

Hi,
I am making changes to an Access application that was written by a
previous coworker.

All I am tring to do is to get the text from a text box called
txtDate, and assign it to a string variable.
************
Here is my code:

Private Sub Button1_Click()

Dim sDate As String
sDate=txtDate.Text
*******************
Here is the error from Access/VB
"Compile error: Expected: end of statment"
********************

Can someone tell me why this doesn't work? How can I get the text
value from the text box and reassign it to a variable?

Thank you in advance,
Eddy

[asdfg2k]

On 5 Aug 2004 13:04:27 -0700, ed********@hotmail.com (eddie wang)
wrote:

Hi,
I am making changes to an Access application that was written by a
previous coworker.

All I am tring to do is to get the text from a text box called
txtDate, and assign it to a string variable.
************
Here is my code:

Private Sub Button1_Click()

Dim sDate As String
sDate=txtDate.Text
sDate = me.txtDate

sDate = me.txtDate.value

When you run into a problem like this, type crtl-G and enter debug
mode. Then you can play around with things until you get the right
syntax.

Typing:

? txtDate.Text

should generate the same error

but, typing

? txtDate.value

shouldn't.

me.$0.02

ringo
*******************
Here is the error from Access/VB
"Compile error: Expected: end of statment"
********************

Can someone tell me why this doesn't work? How can I get the text
value from the text box and reassign it to a variable?

Thank you in advance,
Eddy

[eddie wang]

Thank you so much for the help!!

xx*@invalid.net (asdfg2k) wrote in message news:<41***************@news.INDIVIDUAL.NET>...

On 5 Aug 2004 13:04:27 -0700, ed********@hotmail.com (eddie wang)
wrote:

Hi,
I am making changes to an Access application that was written by a
previous coworker.

All I am tring to do is to get the text from a text box called
txtDate, and assign it to a string variable.
************
Here is my code:

Private Sub Button1_Click()

Dim sDate As String
sDate=txtDate.Text

sDate = me.txtDate

sDate = me.txtDate.value

When you run into a problem like this, type crtl-G and enter debug
mode. Then you can play around with things until you get the right
syntax.

Typing:

? txtDate.Text

should generate the same error

but, typing

? txtDate.value

shouldn't.

me.$0.02

ringo

*******************
Here is the error from Access/VB
"Compile error: Expected: end of statment"
********************

Can someone tell me why this doesn't work? How can I get the text
value from the text box and reassign it to a variable?

Thank you in advance,
Eddy