Hello. Someone please help..... I have an unbound text box on a subform which is created from a paramater query.. Quite simply the text box is a counter for the number of records returned from the query. I have the unbound text box placed within the footer, as was told is good practice. Every thing works fine as long as the query returns one or more records; however i would like to return "0" no qutoes., when no records are retrieved.
My unbound text box data source is as follows:
=Count([Message_ID])
Have tried this, to no avail
=Nz(Count[Message_ID],0) also tried
=Nz((Count[Message_ID]),0)
Nothing seems to work also have tried several Iif statements as well. Anyone have any suggstions. ... ALso would like to call this same field from a different form, can call fine and again as long as not null everything works fine....but when null....##ERRRORRRRRRRR.... please help the weak and distressed.
My unbound text box data source is as follows:
=Count([Message_ID])
Have tried this, to no avail
=Nz(Count[Message_ID],0) also tried
=Nz((Count[Message_ID]),0)
Nothing seems to work also have tried several Iif statements as well. Anyone have any suggstions. ... ALso would like to call this same field from a different form, can call fine and again as long as not null everything works fine....but when null....##ERRRORRRRRRRR.... please help the weak and distressed.