Text in Number field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Field is being truncated after simple query is run, even though nogrouping is taking place 1
Create duplicate from fields Plus auto generate 1
Form field lookups to next record-compex 0
Trying to add Long Integer field 1
Return the current date in a field on a form 5
DateAdd 5
Display of Null date vs. 12/30/1899 2
Date search query 0

Back
Top