VBA Editor has mind of its own

[crhodus]

I'm trying to write some code, but when I save it, VB changes my field name.

When I select save,
COMPANY_ID-Status.Enabled = True
is changed to
COMPANY_ID -Status.Enabled = True

This causes a compiler error when I try to run the code.

Is my naming of the field name incorrect, or is the VBA Editor causing the problem?

Thanks!




[This message has been edited by crhodus (edited 05-23-2001).]

 

[Robert Saye]

Try surrounding your name with square brackets. Also it is recommended that you never use and characters other than letters, numbers, and underlines. If you do you have to use square brackets (This includes spaces.)

[COMPANY_ID-Status].Enabled = True

HTH
Robert

 

[crhodus]

Thanks Robert. That did it.