×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Last figure in a text box is partially cut off when conditionally formatted as italics

Last figure in a text box is partially cut off when conditionally formatted as italics

Last figure in a text box is partially cut off when conditionally formatted as italics

(OP)

See example where the right-most part of the zero is cut off. Using Microsoft 365 Access. Need to know how to make the entire number show up completely.
Thanks.

RE: Last figure in a text box is partially cut off when conditionally formatted as italics

> Using Microsoft 365 Access.

Not enough info. How is the text being displayed? Separate textboxes? Rich text boxes? Labels?

RE: Last figure in a text box is partially cut off when conditionally formatted as italics

(OP)
Problem is with a simple standard text box on a form displaying a numeric field from a query. Problem occurs no matter the font size, nor whether bold or not bold is used, nor whether #,### formatting is used. I switched to "centering" instead of right-justification, and the clipping no longer happens. I would have preferred to right-justify the column of figures but it was not critical in this case.

Thank you.

RE: Last figure in a text box is partially cut off when conditionally formatted as italics

Does setting non-zero right margin help?

combo

RE: Last figure in a text box is partially cut off when conditionally formatted as italics

Try a different printer driver

RE: Last figure in a text box is partially cut off when conditionally formatted as italics

(OP)
I have tried 0 right margin, one of 0.4: same problem. Tried making the text box much wider; that final italic number is still clipped. Also tried making the border solid: no effect.

Currently I am working on a Lenovo P70 Windows 10 laptop. Looks like this is a problem which has existed for a long time. I tried the same things, using a different database, on a Windows 7 laptop: had the same clipping problem.

Trying a different printer driver was suggested. My problem is on the screen. I'm not printing anything.

If you don't want your numbers to look like they are marching off behind the current, stage left, then avoid italics for numeric data. But playing around with it, I did discover a fix: Instead of:
Control Source: [MyField]
you can use:
Control Source: =Format([MyField],"#,###") & Space(1)
You get beautiful, complete digits all the way to the end. Of course, you have changed to displaying text display instead of numbers, but it's just for looks anyway.

Thanks to those who offered help.

RE: Last figure in a text box is partially cut off when conditionally formatted as italics

>My problem is on the screen. I'm not printing anything.

I am aware of this. However, MS Office applications use the current print driver to helo configure certain screen and font metrics, and this sometimes leads to anomalies on the screen. Changing to an alternate driver can sometimes alleviate this.

Alternatively, you may be using a font that does not have its own italic face, in which case Access (well, Windows) italicises it for you. But the display font metrics are calculated against the non-italic face, leading to clipping. You can check what faces a font actually has available through Windows Settings > Personalisation > Fonts

RE: Last figure in a text box is partially cut off when conditionally formatted as italics

(OP)
Thank you, strongm. There is always something more to learn about Windows, and particularly about Access!

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close