Hello, everyone. I have a challenge that I just can't figure out. I
engrave personalized ID bracelets. The form is submitted to MSaccess
via my internet order form. I have 5 fields the customer fills out,
such as Line1, Line2, Line3 and so on. I would like to add another
field where it take all the Lines and combines them and makes a block
of text centered. Centered is very important. See example

JerryScary
1234 Anystreet Ave.
New York, New York
(925)555-1212

Im not sure the above example will remain centered after I submit this
post, but you get the idea.

Once I get this block of text I need to convert it to bitmap. Thats
the only way my engraver will accept it.

So my two questions are. How do I combine fields with line breaks and
also make it centered text?

How do I convert a block of text to bitmap so I can export it as a
image?

Thanks alot.
Jerry

I'm not a big Access expert, but I have done something similar on a small
scale. Create a mail merge into a Word document.
This will allow you to get your lines set up and centered the way you want
on a document.
Export this into Powerpoint (Don't know if a mail merge can be done into
PowerPoint?). From there it can be saved as a Bitmap.
It's possible(probable) that one of the local Access guru's will have a
better method, but thats my solution.
A VBA macro could do it all for you, but if you don't write it, you'll have
to find someone who could.

--

/ Sean Mc /
Replace the "wish" with the screen name to contact.

"I have not failed. I've just found 10,000 ways that won't work."
- Thomas Alva Edison (1847-1931)

"JerryScary" <jerryc916 (AT) frontiernet (DOT) net> wrote

You may consider creating a report for your problem. You can work with the 5
separate fields and creat 5 lines on your report. Centering is easy in this
manner.

A tool to make a graphic file (GIF, PNG) could be DOT. This is a program
that can create a graphic from a text file. Search the web for dot, dotty
and neato to find the website. It's freeware.

To combine the lines into one you can indeed create a fifth field (a memo
type field). I do not know why you want the text as one string, but I would
choose a button AND a memo-field. In this manner you can manually change the
text and by pushing the button re-create the string.

Example:
You have fields txt1, txt2, txt3, txt4. txt5.
The memo field is memo1.

The code for the click-event of the button would be:

private sub button_click( ... )
'defined on this form:
'dim txt1 as string

'dim txt2 as string
'dim txt3 as string
'dim txt4 as string
'dim txt5 as string
'dim memo1 as string

with me
!memo1 = trim(!txt1) + chr$13 _
+ trim(!txt2) + chr$(13) _
+ trim(!txt3) + chr$(13) _
+ trim(!txt4) + chr$(13) _
+ trim(!txt5)
.refresh
end with
end sub

Success...


"JerryScary" <jerryc916 (AT) frontiernet (DOT) net> schreef in bericht
news:696633d8.0310041224.54841de (AT) posting (DOT) google.com...