Unanswered: VBA in Access 2003
I'm having trouble writing some VBA in Access 2003. Normally if I'm writing If statment's in VBA that need to check conditions on textbox I'd write something like this
If (txtBoxName.Text) <> "condition" then
' do something
' do something else
This had always worked in VBA for Access 2000 but I'm getting Run-time errors with Access 2003. So, I've found that I can also write the following code now in Access 2003:
If (txtboxname.value) <> "condition" then
'do something else
My problem is this. I get the runtime errors (can't access referenced control...) if I use the .text function... and sometimes by .Value command is returning a value of "" even though there is text entered...
Any ideas on why this is coming back Null, even though there is data in the textbox?