'Label' doesn't print on my report

[martinbanks]

I have a report which shows dimensions, which are in text boxes, and in between them I need 'x's

ie 25½ x 16 x 2¾

I have put the 'x's in as labels and they appear fine on the report view but when you print it they vanish. The Visible property sheet is Yes and the Display When is Always. There is no code in the report that changes any of the properties in any of the event and no code at all in the On Print event.

Any ideas why this isn't appearing?

(I had the idea of formatting the first to sizes to show the number then a space and an 'x', but this wouldn't work as the dimensions need to be centred within their box so the 'x's wouldn't line up, ie 25¼ x wouldn't line up underneath 8 x)

 

[vbaInet]

What if you put it in a textbox?

Besides that it could be that one of the controls is overlapping it during print.

 

[martinbanks]

What if you put it in a textbox?

Besides that it could be that one of the controls is overlapping it during print.

I have tried it as a text box but I don't know how to have a text box just display text. It seems to want to be bound to something.

I just tried adding in a field to the query this report reads with the formula: Expr3: IIf([SortLength]>0,"x","")
SortLength will always be above zero, so I thought that would work fine, but it is bringing up a box now when you open the report as if SortLength is a parameter, when it's not it's an expression on the same query. If you don't bother entering a value and just click ok it gives the right result, but.... it still doesn't show on the print preview.

Then I tried changing the Can Shrink property to Yes and hey presto, it's there!! That property isn't available as a label so it looks like I need to do the same for the other 'x' and then use SetWarnings to False in vba to get round this.

Very odd solution though, can anyone see how it could've been much simpler?

 

[vbaInet]

To set a textbox's control source as just text, you precede the text with an equal to sign and enclose the text in quotes, like so:

="My text here"

 

[martinbanks]

SetWarnings = False doesn't suppress Parameter boxes it seems.

 

[martinbanks]

To set a textbox's control source as just text, you precede the text with an equal to sign and enclose the text in quotes, like so:

="My text here"

Outstanding, thank you. I could've sworn I tried that but evidently not.

For anyone else having the same problem though, the solution to making it appear still lay in the Can Shrink property. Set that to No and it vanishes from the print but not the report view. Set it to Yes and bingo

 

[vbaInet]

Glad you got that fixed.