Puttting "......" lines in report

[PeterAccess]

Hi everyone,

Is there a way to put guide lines in report? My report has a lot of fields and the space between the label and textbox control are far apart. When the report is printed, this will help the user with matching the label and the relevant textbox control.

e.g

Agent name.........................................John Smith

How do you make the "....." shrink and grow depending on the length of the name control?

thanks!

 

[dhookom]

Have you tried setting the caption of the label to:
Agent Name................


Duane
Hook'D on Access
MS Access MVP

 

[PeterAccess]

Hi dhookom

I have but it doesn't work for me.

See attached link for more information.

My attached example is

Are Owners Corporation Books and Records maintained correctly?..........Yes

I need the ".,..." to extend or shrink to BooksMaintained control depending on the size so that there is no gaps.

help!!

 

[dhookom]

It looks like the image shows how the dots will "help the user with matching the label and the relevant textbox control". What about the solution don't you like? Where are the gaps?

If the text box on the right is right-aligned, you might try Stephen Leban's leader dots.

Duane
Hook'D on Access
MS Access MVP

 

[PeterAccess]

Hi dhookom,

The first image was in Design mode to let you have look behind the scene.

I have attached another image here to show what happens in Preview mode.

You can see that the "...." label doesn't really extend to the word "Yes". I think my BookMaintained control in Design mode is too wide and have ordered the BookMaintained control to front and the label to back. I have set the Can shrink property to Yes but it doesn't seem to shrink in Preview mode.

If I set the label to front and BookMaintained control to back and if I have a long data in BookMaintained, then the control will overlap the "...." (See Situation 2)

What do I do?

thanks

 

[PeterAccess]

Let me have a look at your link on leading dots page. It looks to be what I need. Will get back to you dhookom