Text in Number field

N

Newbie

I have a number field set as a long integer (SavAcctNum). When you enter the
savings account number, it sets a date field (SavDateOpen) to todays date.

When I had someone test my database, they entered 'NO' in the SavAcctNum.
Instead of giving them the "The value you entered isn't valid for this
field." message, it set the SavAcctNum to 0 and the SavDateOpen to 12/30/1899.

I have another number and date field set up just like this and it won't
allow text. Any ideas?
 
S

Sharkbyte

The '0', posted in the table, comes from the default value for that field (in
the table).

As for not receiving the error, it is something on your form. Did you
SetWarnings to False? As a possible fix, try setting the DataType, on the
form control, for your Savings Account to a number based type (Fixed,
General, etc.).

Sharkbyte
 
Top