How do we clear out a field?

[erictheman]

Hello, what's the code to clear out field(s) in Access? (Take note I'm using Access 97) What I mean is that say if you had 4 fields. Employee name, Address, Phone, and Position. You want to keep the employee name, address, phone and clear out position field when you click a button. Exp. Clear button. What code do you use? I try to use [Position] = "" and ([Position]) = "" but it doesn't work. It brings an error message saying field cannot be zero-lenght string. Thank you very much for your help.

 

[CajunCenturion]

Sounds like the problem may be in the table definition. If you open that database access and then select table defintion, you can go down to that field, and see what the values for Required and AllowZeroLength. I would set Required to NO, and AllowZeroLength to YES. Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[erictheman]

Yes it works! Thank you for your help CajunCenturion!

 

[Snipor]

[Position] = Null

would work also.........