Fill blank fields with any char

  • Thread starter Thread starter manish
  • Start date Start date
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
 
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,
"-").
 
Dear Jeff
Thank u very much for the explanation - it was well
explained.
Warm regards
manish
 
Back
Top