Format Problem

  • Thread starter Thread starter marcfromm via AccessMonster.com
  • Start date Start date
M

marcfromm via AccessMonster.com

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?
 
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.
 
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 said:
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
Click to expand...
[quoted text clipped - 7 lines]
Is there a way to fix this format issue with Text Align set to the Right?
Click to expand...
Click to expand...
 
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 said:
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 said:
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
Click to expand...
[quoted text clipped - 7 lines]
Is there a way to fix this format issue with Text Align set to the Right?
Click to expand...
Click to expand...
Click to expand...
 
Back
Top