Format Problem

  • Thread starter marcfromm via AccessMonster.com
  • 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?
 
G

Guest

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.
 
M

marcfromm via AccessMonster.com

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
[quoted text clipped - 7 lines]
Is there a way to fix this format issue with Text Align set to the Right?
 
G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top