troubleshooting Question

Using a Report to populate pre-printed form - letter in the box style?

Avatar of namedpipes
namedpipes asked on
Microsoft Access
6 Comments1 Solution423 ViewsLast Modified:
I need to print content onto a preprinted form (LaserJet). I have to use the preprinted form. It cannot be rendered by the report.

The form has individual squares to place each character (originally filled in by hand). So, instead of placing a text field for lastname somewhere on the page I have to place each character in the last name in the next square. Something like this:   (The square brackets would represent the pre-printing, not what I'm reporting)

  [ L ]  [ A ]  [ S ]  [ T ]  [ N ]  [ A ]  [ M ]  [ E ]  [   ]  [   ]  [   ]  [   ]  [   ]  [   ]

What is the best way to get there from here?

Two approaches occur to me and I don't like either one:

1) Place 25 last name fields on the report and set the formatting for each one to substr the proper character for this square, something like substr(lastname, 5, 1) in the 5th square. The repeat for the other 40 data items on the report.

2) Write a module that prints directly to the printer and print off a trillion sheets while I microscopically index each position, completely ignoring the report feature. Actually, if no better solution pops up this is what I'll do. . .
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 1 Answer and 6 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 6 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros