Text Box to Variable

[B-dub]

I'm struggling with the code to assign the contents of a text box to a variable. I've tried VendorNameVar = Me.txbxVendorName.Value and VendorNameVar = Me.txbxVendorName.Text. I've tried triggering the code from various events (On Change, On Exit, On Lost Focus, etc). I've tried declaring my variable both at the module level and procedure level but my variable never obtains a value. I'm sure it's a fundamental error by a rookie. Any Thoughts?

[ajetrumpet]

my first thought would be that you're missing something very simple, or not disclosing it in your post, whether you know it or not.

var=me.box should work just fine if you're writing the code in the form's actual module. are you sure you're typing it there? You can test this for sure by seeing if the NAME of the box appears in the dropdown list that appears after you type "me."

if you're in the right place, it will be in the list. If you have no list and you're typing in the form module, you have the intellisense option turned off.

the other thing to note is....HOW do you know that the var is not getting it?? If you're assuming, it's not a valid statement. Did you know you can follow variable values in the vbe through code, line by line?? there's a watch window you can view that will show you every variable, follow each ones value and detect when the value changes.