Object required error

[robins80]

Hello,

I have a form in Access with a text box called ChooseZone. I want to put the value of ChooseZone.Text into a variable called ThisText like so:

ThisText = ChoozeZone.Text

but when I run the application, the above line gets the oh-so-descriptive error "Object Required".

What gives? Shouldn't this be a simple operation?

Thanks,
* Robinson

 

[SkipVought]

Hi,

ThisText = [b]SomeFormObject.[/b]ChoozeZone.Text

Skip,

_[red][/red]

 

[PHV]

Furthermore, in Access, the Text property of a TextBox is only available when the control has the focus, so use its Value property instead.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[robins80]

I changed the line to this:

ThisText = ProgramForm.ChoozeZone.Text

And still got the same error.

 

[SkipVought]

Hit the Debug button when you get the error.

Select ProgramForm and view the Watch Window.

What does it say about this?

Skip,

_[red][/red]

 

[PHV]

Provided that ProgramForm is an open main form:
ThisText = Forms!ProgramForm!ChoozeZone.Value

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[robins80]

Actually, I decided to change my variable to a Variant and everything seemed to work fine. Thanks for the help.

 

[SkipVought]

"...change my variable to a Variant "

FROM what?

Skip,

_[red][/red]

 

[robins80]

It was originally defined as String. Sorry.