Solved Form letter as report

[icantprint]

Hi Everyone!

I can't believe this is so difficult. I have a simple database - customer table, a query that selects all customers coming up for renewal (say 30 days). What I'm trying to do is generate a letter to these customers. Everything is working fine, except when I try to view the report (in print preview), a dialog presents to ask for a parameter value for the body of the letter. It's simple text, in an unbound text box. (Not shown here for privacy). Again, everything else is working correctly, I just can't get the letter body to appear, or stop the parameter dialog. Also, the text format is set to "Rich Text". There is nothing in the body that relies on field or query data - it's just text. Thank you very much for having a look!

 

[theDBguy]

Hi. Welcome to AWF!

What is the Control Source you're using for the unbound textbox?

 

[DHookom]

So the "body" is the large control that is selected in your design view? Is the control a label or a text box?

 

[plog]

That dialog is because you told it a field name that isn't actually a field name. Whatever that dialog is asking for is the culprit. Most likely it's a typo on your part. You told it to find [ZIP] but the actual field name is [ZIPCODE] or you told it to use [CITY] but misspelled it in the query to [CIITY].

This could either be in the report itself, or if that report is based on a query, in the query. So, if a query is being used, check there first. If the dialog doesn't appear when you run the query alone, then go to the report.

Lastly, and this might be the issue, [NAME] is a poor name for something in Access. That's because its a reserved word inherent to Access and when you use it as a name it confuses the system. Even if [NAME] isn't the culprit, I suggest you change the field name by prefixing it with what it is the name of (e.g. CustomerName, MemberName, etc.)

 

[icantprint]

That dialog is because you told it a field name that isn't actually a field name. Whatever that dialog is asking for is the culprit. Most likely it's a typo on your part. You told it to find [ZIP] but the actual field name is [ZIPCODE] or you told it to use [CITY] but misspelled it in the query to [CIITY].

This could either be in the report itself, or if that report is based on a query, in the query. So, if a query is being used, check there first. If the dialog doesn't appear when you run the query alone, then go to the report.

Lastly, and this might be the issue, [NAME] is a poor name for something in Access. That's because its a reserved word inherent to Access and when you use it as a name it confuses the system. Even if [NAME] isn't the culprit, I suggest you change the field name by prefixing it with what it is the name of (e.g. CustomerName, MemberName, etc.)

Yes, I'm aware of these issues - I've inherited this thing to fix, and the first priority is to get the reports working ASAP. A complete restructure is in order, but the bleepin text are thing has been driving me crazy. Turns out, it wasn't a label control.

 

[icantprint]

So the "body" is the large control that is selected in your design view? Is the control a label or a text box?

It was a text box, I think - I've since made it a label, and it seems to be working. Forgive me - I think my question was premature. I should have started from scratch.

 

[icantprint]

Hi. Welcome to AWF!

What is the Control Source you're using for the unbound textbox?

No control - just text, and I thought I was dealing with a label, but it was not.