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
|
|||
|
|||
Using access data to fill-in pre-printed report forms
Aside from using the cumbersome mail merge, is there a decent way to take
access data and use it to fill-in a printable form? By "form" I mean like a tax return, not an access "form." |
#2
|
|||
|
|||
Using access data to fill-in pre-printed report forms
You can set up a report so that it looks like a government form, and merge
the data. Suggestions: 1. To embed someone's name into a sentence, the Control Source of your text box would look something like this: ="Thank you " & [FirstName] & " " & [Surname] & " for your offer." & Chr(13) & Chr(10) & "Another line of text." 2. A report section can be only 22" tall. If you need more space, you can create extra sections. Open the Sorting And Grouping dialog (View menu), and choose the Primary Key field. In the lower pane of the dialog, set Group Header and Group Footer to Yes. This gives you 2 more sections that can be 22" tall also, and since it's the primary key it occurs for all records. If you still need more space, you can choose the primary key field again on the next row of the dialog. 3. The text box in Access is text only, so you cannot bold part of sentence, use indented bullets, or change font size in the middle of a text box. With effort, it is possible to use a rich text box such as this one from Stephen Lebans: http://www.lebans.com/richtext.htm -- 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. "S.Hanagan" wrote in message ... Aside from using the cumbersome mail merge, is there a decent way to take access data and use it to fill-in a printable form? By "form" I mean like a tax return, not an access "form." |
#3
|
|||
|
|||
Using access data to fill-in pre-printed report forms
What type of tax form? I have done the new 941's but I am not going to try
a 1040 or 1120. Mike "S.Hanagan" wrote in message ... Aside from using the cumbersome mail merge, is there a decent way to take access data and use it to fill-in a printable form? By "form" I mean like a tax return, not an access "form." |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
PST file has reached maximum size | Jeff C | General Discussion | 2 | October 6th, 2005 01:35 PM |
Unable to have multiple queries feeding a single report | PZ Straube | Setting Up & Running Reports | 15 | June 15th, 2005 08:16 AM |
exporting accress reports into word | marc | General Discussion | 8 | December 29th, 2004 04:40 PM |
Access XP Compared to Access 2003 | Mardene Leahu | New Users | 1 | October 1st, 2004 05:11 AM |
Adding staff photographs to my database | KK | New Users | 2 | September 3rd, 2004 07:41 AM |