In the report I am creating I would like to set the Blank or Null fields for a text box to display "N/A". I cannot seem to find some sort of a default setting and I would not like to do this in the Form for certain reasons. Thanks
In the report I am creating I would like to set the Blank or Null fields for a text box to display "N/A". I cannot seem to find some sort of a default setting and I would not like to do this in the Form for certain reasons. Thanks
IIF([field] is null, "N/A", [field])
where field is the column that would have a null value
Thanks, but I keep getting an invalid control property error and a circular reference error. My exact code is below:
=IIf([Note] Is Null,"N/A",[Note])
Anymore suggestions?
I don't know...that's exactly what I have in the text box and it works for me just fine
Note is a reserved word in Access. Try changing it's name and see if that works.
Thanks for the responses, but I solved it. Instead of doing this in my Control Source, I moved the function to the underlying report query. Works great and I adapted it for other fields.
Hi I noticed this thread was marked as solved, but i've tried your solution and it hasn't worked
I have a database where customers join a programme of home care. The programme is intended to start on the same date as the referral, however for many reasons the programme can be be delayed. Under these circumstances, a referral data AND a start date is entered. A reason from delayed programme start date is meant to be entered as well.
I have created a query which lists all the programme start dates and the reasons, and thn a report which groups by reasons. however there are a large proportion of entries where no reason has been chosen. In my report, this section has no heading, and is just a floating number.
I entered your formula in the underlying query but all it did was remove the blank entries and only counted the entries which had a reason entered therefore providing a false representation of all delays.
here is the formula I entered in my query:
IIf([ReasonForDelayedProgrammeStart] Is Null,"No Reason Given",[ReasonForDelayedProgrammeStart])
Any suggestions please?
Many thanks
l3111, Manchester, England