Hi!
VB and VBA equivalents of WHEN and VALID are GotFocus and LostFocus events.

>Perhaps I'm approaching this all wrong. I'm trying to show currency data in a textbox on a form. The textbox is not bound to a field on a sheet. In DOS and Win16 versions of FoxPro, there were WHENs and VALIDs where I could kludge- format the textbox. No such event in VBA.
>How would I go about formatting a textbox in VBA? No tutorial that I've found (using Google, I've found a *lot*!) covers this topic. Help doesn't mention where this would be done, either. There is no 'Format' property in the property sheet.
>Please help, and thanks in advance.
>Regards,
>Robin