If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
#Error in text box
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 |
#2
|
|||
|
|||
#Error in text box
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(). -- 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. "Memphis" wrote in message ... 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 |
#3
|
|||
|
|||
#Error in text box
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 "Allen Browne" wrote: 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(). -- 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. "Memphis" wrote in message ... 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 |
#4
|
|||
|
|||
#Error in text box
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])) -- 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. "Memphis" wrote in message ... 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 "Allen Browne" wrote: 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(). "Memphis" wrote in message ... 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. |
#5
|
|||
|
|||
#Error in text box
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 "Allen Browne" wrote: 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])) -- 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. "Memphis" wrote in message ... 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 "Allen Browne" wrote: 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(). "Memphis" wrote in message ... 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. |
#6
|
|||
|
|||
#Error in text box
Yes, testing the HasData property of the report would also be a good
solution. Great. -- 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. "Memphis" wrote in message ... 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) |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Linking text boxes | Volunteer Mom | Publisher | 7 | November 12th, 2008 01:29 AM |
Ideas On Producing Envelopes & Labels For Data | RNUSZ@OKDPS | Setting Up & Running Reports | 0 | April 28th, 2005 03:22 PM |
Combo Box (1st) Populating Text Box (2nd) Field | AccessRookie | Using Forms | 1 | April 6th, 2005 11:37 PM |
Access reports with a horizontal line after each record??? | Bill via AccessMonster.com | Setting Up & Running Reports | 6 | March 9th, 2005 04:51 PM |
Concatenatd fields in a query for a searching form | Marc | Running & Setting Up Queries | 8 | October 19th, 2004 08:49 PM |