#ERROR in field on new record

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

Guest

Hi

I have a peice of code that generates a number and from that and another
field the month and yr is calculated. This works fine but the problem is that
on the new records line in the continuous form it shows #ERROR because the
number hasnt' been generated to calculate the month and yr with. Is there
anyway i can stop it showing #ERROR of have cond formatting to make field
same colour as background?

Cheers

Danny
 
You could make a default value for the field. Something like 0 or a nonsense
date.
 
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

Updating tables when you input new data 0
Tagging 17
DateAdd in calculated field 3
DateDiff on blank fields? 4
Concatenate Date and Number field for Append Query 0
Order entry 5
Beginner Question - Month Field 3
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0

Back
Top