Access 2007 - Can not blank a Field

[Hap007]

Hi,

Have wierd problem and I am not sure if it is a Access 2007 issue

I have a form, linked to a MySQL Backend

To keep it simple, I have a Text field defined that has property of no Nulls allowed.

On the Access form, If The field has a value and I blank it out, I get an error message stating nulls are not allowed.

I am entering a space, but access seems to truncate to a null.

If I set the field definition to allow nulls, it works fine.
I can also the test for nulls on the 'AfterUpdate' and set to a space then.

So, is there some setting I can make so that a space entered is treated as a space when entering text into a text box?

Thanks,
Hap...


Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Accounting Solutions - with free source code
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121

 

[PWise]

See Remou's 2nd post in this thread

http://www.tek-tips.com/viewthread.cfm?qid=1497960&page=1

Private Sub txtText_KeyPress(KeyAscii As Integer)
    If KeyAscii = 32 Then KeyAscii = 160
End Sub