Form Section; Need "N/A" as Default in a Field

[netchie]

Hi,

One of the fields on my form has ID field (can input either number, text, or both). It looks unprofessional when I am printing reports for ID because some are blank. How can I make that field to have automatic "N/A" when the field is blank? I put ="N/A" as Default Value but no use.

Thanks for your help in advance



netchie

[June7]

You can either set the default in the table so that new record is created with this value and then can replace it in data entry. Or in report textbox control source use expression: =Nz(ID, "N/A")

[netchie]

Hi June 7,

Thanks for your advice. I forgot that my ID field is not allowing duplicates so I think it will kill the purpose if it's automatic N/A. Any other ideas?

How about when they left it blank, a new pop-up will appear saying they need to put N/A? Oh, again, I forgot it will still be a duplicate, bummer! Is there something like no dupliclates except the word "N/A"? How can I do that?

Your help is as always highly appreciated

Thanks,
netchie

[June7]

Why are they allowed to leave a blank? How is the ID generated?

Just do the expression in report textbox to handle the null.

[netchie]

Sometimes supplies have ID#s and some don't have them that's why the report is showing some blank ID#.

Again, thanks for your time and advice

netchie

[June7]

Solved?

The Nz suggestion will work as long as empty strings are not allow in the table field.

[netchie]

Yup! solved

Thanks June7!

netchie