Nulls

[vbnetman via AccessMonster.com]

Good evening,
I've got a form with a yes / no dialog box that is used to accept / reject
data changes. When the user decides "NO", I want to close the form and exit
(docmd.close). At the time the user makes this selection, 2 text boxes
representing 2 fields are populated by design. I want to empty those just
prior to closing. I've used textbox1 = "" and textbox2 = "" (empty strings).
Access views this as a null and will not accept it. I can hide the warnings
but this does not really solve the problem. I've also tried textbox1 = 0 and
textbox 2 = 0 but these are actually values. Has anyone encountered this and,
if so, how did you resolve it.
Thank you

 

[Arvin Meyer [MVP]]

Using the Escape (ESC) key, or in code:

Me.Undo

will return the form to its original, unsaved data. (assuming that you don't
have a subform on it, and have already saved the mainform data by moving to
the subform.)
--
Arvin Meyer, MCP, MVP
Free MS-Access downloads:
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Van T. Dinh]

Check the Properties "Required" and "AllowedZeroLength" of the Fields in the
Table DesignView.

These 2 Properties works together to allow different values in the Field,
e.g. Null, empty String, nomal value ... so you need to check Access Help to
find the right combination for you.

 

[vbnetman via AccessMonster.com]

Thank you for the tips!

Using the Escape (ESC) key, or in code:

Me.Undo

will return the form to its original, unsaved data. (assuming that you don't
have a subform on it, and have already saved the mainform data by moving to
the subform.)

Good evening,
I've got a form with a yes / no dialog box that is used to accept /

[quoted text clipped - 13 lines]

if so, how did you resolve it.
Thank you