quick question abt Null fields (1 Viewer)

[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

 

[Pat Hartman]

On a report it would be no problem. Either in the query or in one of the controls -
IIf(IsNull(Fld1), "Exception", Fld1)

However, a form is more of a problem because calculated fields (which is what this would be) are not updatable. You would need to hide the real field and use an unbound text box to handle data entry.

 

[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).

 

[Pat Hartman]

If the field in question is text and long enough to hold the word, you can make "Exception" the default value. That way if no value is entered, the default will be assigned. Otherwise there is no way.
As a point of good application design, you should NOT be using tables directly for anything. You should be using forms and reports with recordsources based on queries.

 

[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