Text within report labels different size in preview/print

[RichO]

I have always noticed that when creating a report, when you make a paragraph using a label, the alignment and size of the text/paragraph is always different when you preview the report than when you design it.

This makes alignment of paragraphs tricky, especially when you are trying to insert a bold faced word into the middle of a block of text by using a separate label.

Is there any way around this or is that just the way it is?

I am using Access 2000

Thanks

 

[CJ_London]

can you clarify your terminology - do you mean labels or textboxes? And what do you mean by

trying to insert a bold faced word into the middle of a block of text by using a separate label

 

[RichO]

I am using an actual label as shown by the arrow, not a text box. Because you can't mix normal and bold text within a label or text box, when you want a bold faced word you need to create a separate label or text box and place it within the other text.

Here is an example of the difference between design and preview.

Notice how when in design mode the words "the" and "and" are the right most words in the first 2 lines but when you preview it, the alignment is different and now the words "text" and "printing" are at the right end of the first 2 lines.

 

[CJ_London]

Ah OK. Although if you upgraded to 2007 or later you can use bold/underline/italic etc in a memo field (not a label)

Suggest you look at and adapt Stephen Lebans cangrow function to determine the correct values for left and top for your small label given the text that appears to the left of the small label. I use something similar for overlaying images into text

http://www.lebans.com/cangrow.htm

 

[RichO]

OK thanks. We are going to be upgrading to Access 2010 in the next few months so then I guess I can utilize the memo field for that.

I will check out that link though.