A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Setting Up & Running Reports
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Format Problem



 
 
Thread Tools Display Modes
  #1  
Old July 20th, 2007, 12:01 AM posted to microsoft.public.access.reports
marcfromm via AccessMonster.com
external usenet poster
 
Posts: 9
Default Format Problem

I have a report of a crosstab query. I formatted the left column of the
report with Text Align set to Right. The report is chopping off the last
character of the term, even if I set the Right Margin to 0.5". Doing so just
puts space between the right edge of the border and the end of the chopped
word

I have played with all of the format settings in the properties with no
success. If I set Text Align to Left the word is not chopped, but I would
prefer Text Align set to right.

Is there a way to fix this format issue with Text Align set to the Right?

--
Message posted via http://www.accessmonster.com

  #2  
Old July 20th, 2007, 04:32 AM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Format Problem

I'm not sure what is causing this. You might want to try different fonts
and/or a different printer.

Another possible solution is to change the Control Source to something like:
=[Your Field] & " "
Make sure you change the name of your text box so it is not the name of a
field.
--
Duane Hookom
Microsoft Access MVP


"marcfromm via AccessMonster.com" wrote:

I have a report of a crosstab query. I formatted the left column of the
report with Text Align set to Right. The report is chopping off the last
character of the term, even if I set the Right Margin to 0.5". Doing so just
puts space between the right edge of the border and the end of the chopped
word

I have played with all of the format settings in the properties with no
success. If I set Text Align to Left the word is not chopped, but I would
prefer Text Align set to right.

Is there a way to fix this format issue with Text Align set to the Right?

--
Message posted via http://www.accessmonster.com


  #3  
Old July 20th, 2007, 03:50 PM posted to microsoft.public.access.reports
marcfromm via AccessMonster.com
external usenet poster
 
Posts: 9
Default Format Problem

This situation has become weirder. I opened the db on my home computer and it
looked great--no chopped off letters. On my work computer the letters are
chopped off and the printout is chopped off as well. It is obviously
something to do with this computer that claims to be America's favorite PC.
My home system is self built.

Duane Hookom wrote:
I'm not sure what is causing this. You might want to try different fonts
and/or a different printer.

Another possible solution is to change the Control Source to something like:
=[Your Field] & " "
Make sure you change the name of your text box so it is not the name of a
field.
I have a report of a crosstab query. I formatted the left column of the
report with Text Align set to Right. The report is chopping off the last

[quoted text clipped - 7 lines]

Is there a way to fix this format issue with Text Align set to the Right?


--
Message posted via http://www.accessmonster.com

  #4  
Old July 20th, 2007, 04:04 PM posted to microsoft.public.access.reports
Duane Hookom
external usenet poster
 
Posts: 7,177
Default Format Problem

Did you try different printers and fonts as I suggested? Did you try add a
couple spaces at the end of your control source expression?

--
Duane Hookom
Microsoft Access MVP


"marcfromm via AccessMonster.com" wrote:

This situation has become weirder. I opened the db on my home computer and it
looked great--no chopped off letters. On my work computer the letters are
chopped off and the printout is chopped off as well. It is obviously
something to do with this computer that claims to be America's favorite PC.
My home system is self built.

Duane Hookom wrote:
I'm not sure what is causing this. You might want to try different fonts
and/or a different printer.

Another possible solution is to change the Control Source to something like:
=[Your Field] & " "
Make sure you change the name of your text box so it is not the name of a
field.
I have a report of a crosstab query. I formatted the left column of the
report with Text Align set to Right. The report is chopping off the last

[quoted text clipped - 7 lines]

Is there a way to fix this format issue with Text Align set to the Right?


--
Message posted via http://www.accessmonster.com


 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:57 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.