Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

words separated with dash jam together in report - ?

Status
Not open for further replies.

gusbrunston

Programmer
Feb 27, 2001
1,234
US
I have a table of account codes with text description. i.e., "Refund - utility" and "Refund - other". When I include these in a report, the words surrounding the dash (or minus sign?) jam together. I've had to go to "Refund: utility" and "Refund: other". Anybody know howcome? Thanks,
Gus
 
Hi Gus,
I just ran a sample here and cannot reproduce your problem. I'm assuming that your description field is a text field and "Refund - utility" is not a pair of fields being "blended" together in a query or on the report. If the latter make sure your "blended" expression looks like:
TheBlend: [FirstField] & " - " & [SecondField]. Sorry I can't pinpoint this for you. Gord
ghubbell@total.net
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top