Default Value

  • Thread starter Thread starter Amy Johnson
  • Start date Start date
A

Amy Johnson

HI,

I have a query that links a table and another query. Some
of the fields of the records are blank in the query. When
I make a report out of the query the fields that are
blank are also blank on the report as well. Is there
anything I can do to the report or the query to have a
default value if no data is present?

Thanks
 
Amy said:
I have a query that links a table and another query. Some
of the fields of the records are blank in the query. When
I make a report out of the query the fields that are
blank are also blank on the report as well. Is there
anything I can do to the report or the query to have a
default value if no data is present?
Click to expand...


set the text box's control source to an expression like:

=Nz(fieldname, yourdefaultvalue)

just make sure that the text box is named something other
than the fieldname. If it is, change it to something like
txtfieldname.
 
Back
Top