#Error in text box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Memphis - 02 Dec 2005 15:44 GMT

When I want to print a blank copy of a Report so that I may fill it out
manually, I get a #Error on the text box that was expecting a value.

This is the procedure I have for this text box "Text55":
=Trim([CLFirst] & " " & [CLInitial] & " " & [CLLast])

I would like to get rid of the # Error but I don't know how.

Thanks

Reply to this Message

Allen Browne - 02 Dec 2005 16:08 GMT

When there is no data to print, referring to the text box causes a
calculation error as you found.

You can avoid that with by testing for IsError(), inside IIf().

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> When I want to print a blank copy of a Report so that I may fill it out
> manually, I get a #Error on the text box that was expecting a value.
[quoted text clipped - 5 lines]
>
> Thanks

Reply to this Message

Memphis - 02 Dec 2005 16:35 GMT

Thanks for your reply Mr. Browne,
I am still confused, I tried typing =IIf(isError( )Trim([CLFirst] & " " &
[CLInitial] & " " & [CLLast]) and a couple of different ways but I get an
alert that I am not doing something right and resets the formula back to
where it was.

Could you shed some more light on this?

Thanks
Dax

> When there is no data to print, referring to the text box causes a
> calculation error as you found.
[quoted text clipped - 10 lines]
> >
> > Thanks

Reply to this Message

Allen Browne - 02 Dec 2005 16:43 GMT

You do not have anything inside the IsError() brackets for it to test:

Try something like this:
=IIf(IsError([CLFirst] & " " & [CLInitial] & " " & [CLLast]), Null,
Trim([CLFirst] & " " & [CLInitial] & " " & [CLLast]))

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Thanks for your reply Mr. Browne,
> I am still confused, I tried typing =IIf(isError( )Trim([CLFirst] & " " &
[quoted text clipped - 19 lines]
>> >
>> > I would like to get rid of the # Error but I don't know how.

Reply to this Message

Memphis - 02 Dec 2005 19:56 GMT

It took a while to figure this out but after reading your reply and some
other replies here I was able to piece this together and it works out:
=IIf([HasData],Trim([CLFirst] & " " & [CLInitial] & " " & [CLLast]),Null)

Thank you for your replies

Dax

> You do not have anything inside the IsError() brackets for it to test:
>
[quoted text clipped - 25 lines]
> >> >
> >> > I would like to get rid of the # Error but I don't know how.

Reply to this Message

Allen Browne - 03 Dec 2005 02:53 GMT

Yes, testing the HasData property of the report would also be a good
solution.

Great.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> It took a while to figure this out but after reading your reply and some
> other replies here I was able to piece this together and it works out:
> =IIf([HasData],Trim([CLFirst] & " " & [CLInitial] & " " &
> [CLLast]),Null)

Reply to this Message