quick question abt Null fields

[shafh]

Hi everyone,
I have a table that has a few records in 3 different fields that are empty. Is there any way I can get the table to show "EXCEPTION" in those records rather then leave it blank.
Thanks,
Sam

 

[shafh]

clarification

Thanks Pat,
I think I wrote my question wrong. I wanted the Table to show "Exception" in the empty records. You have mentioned how this could be done in a Report and Form. But is there any way to do this in the Tables view (i.e. when you open the table directly).

 

[jaydwest]

Instead of using IIF, you might use the NZ function. It's simpler and more direct. Code is


NZ(Fld1, "Exception")

 

[shafh]

Thanks

Thanks a lot guys, especially Pat. Setting Default value to "Exception" did the trick.
Sam