Fill blank fields with any char

M

manish

hello everyone.
I wanted to know whether there is any way to fill blank
fields with any character say "-" in reports without
depending upon the field type.
thanks in advance for any response.
regards
manish
 
J

Jeff Boyce

Manish

Different field types may have different representations of "blank",
depending on the underlying table field definitions. For instance, if you
set a text field to allow a zero-length string, you could have a field that
appeared empty (Null), but was actually holding a zero-length string ("").

When you are assured that the field type can only hold a value or a Null,
you can use the Nz() function to force nulls to whatever you wish (say,
"-").
 
M

manish

Dear Jeff
Thank u very much for the explanation - it was well
explained.
Warm regards
manish
 
Top