report like attached, ..... leading tabs

[davefwelch]

I've been working to create a report that will look like the attached word document. I have been able to duplicate everything but the leading .... tabs. Any suggestions?

I thought perhaps I could use the onFormat event in the Report Detail and query the width of the Description and Amount fields, and make the total width of the row a certain value, filling the gaps between with dots. Problem is, Access does not modify the width of a textbox, CanGrow and CanShrink only apply to the HEIGHT of the textbox. The width of the description has nothing to do with the width of the data in the textbox.

 

[DCrake]

Why not try and concat a length of dots to the description text in the underlying query and size the width of the texbox on the report accordingly. If you have the text box left aligned and you set the Can Grow to False then it will truncate the extra dots and appear as though they are trailing dots.

David

 

[stopher]

Hopefully David's solution should do the trick.

Another (not so perfect solution): How about using a fixed-width font such as courier? Then the number of dots needed is easily calculated and concatenated.

Chris