Text cut off even though the text box is large enough

[breezett93]

The first image is the report. The second image is the report's design view. In the design view, I have ensured that the text box is wide enough to fully display what is entered. Any idea why the text is cutting off?

Thanks.

 

[kray4660]

Check for the padding for the box. I normally set it to zero for all four sides.

 

[dhookom]

I assume you are referring to the MarkNo text box. Can you tell us what the actual value is? Is this occurring for all values or just some?

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[breezett93]

The actual value has two more numerical characters. It is happening every time across different items. So, I'm confident the issue is with the box, not the values being entered.

 

[breezett93]

Control margins is set to none. Control padding is greyed out. This is on a subform of a report.

 

[dhookom]

Is there anything in the format property?

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[breezett93]

No, the format dropdown is blank.

 

[dhookom]

Next, I would copy and paste the data values into Word or some other application to determine if there are any hidden characters. Also, try create a calculated column in a query with something like:

Len(MarkNo)

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[dhookom]

Next, I would copy and paste the data values into Word or some other application to determine if there are any hidden characters. Also, try create a calculated column in a query with something like:

Len(MarkNo)

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[breezett93]

Okay, no hidden characters. I added the calculated column and got the correct length on another example.

Full string = ZG207621.RH

The H is fully cut off, and the R is partially cut off.

 

[breezett93]

The cut off definitely happens at a set length, regardless of how long the string is. Another example with one additional character.

 

[dhookom]

I would try all 1s and then Al 0sto see if it’s a character or width issue. Also try different fonts. Do all of the characters display in the data sheet view of the reports record source?

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[breezett93]

All 1s

All 0s

Yes, all the characters are present in the data sheet view.

 

[strongm]

Can you try temporarily changing your printer driver, or select a printer with a different driver?

 

[breezett93]

Good thought. I just tried a different printer, and the text is cut off at the same spot.

 

[dhookom]

Create a new report and try the same text box there.

Duane
Minnesota
Hook'D on Access
MS Access MVP 2001-2016

 

[strongm]

Do you have the same issue in both Report View and Print Preview?