HELP ... Aligning Text Box Borders

[JRA]

Hello,

I really need some help with my VBA code on my Access database. What I am try to do is set-up my report so that all columns that I have bordered with a black boder will align up to the longer border.

Let me explain in more detail. I have a report that has four tect boxes on it. Each text box is bordered with a black line that is part of the input box property. My first text box is just a auto-number, my second and third text box is set to a text property and my third text box is set-up to hold memo capabitities. Anyways, when the report is printed, the first text box border is really short, the second and third are a bit longer and the third is the longest. What I want though is that all four text boxes are the same length when I print the report, lining up with the longest text box, ather than each box being a seperate length.

It has been suggested to me that if I put some code on the 'On Format' event with the Detail section, I might be able to correct this problem. I have no idea how to do this though. I would really appreciate any help because I have to have this sorted out very soon.

Thanks in adavnce,
James.

 

[BoxHead]

James,

In the Report's design view, make sure they are all sized the same to begin with. Then, check that the CanShrink property is set to No.


HTH

John

Use what you have,
Learn what you can,
Create what you need.