Promblems with Report Printing

[rnutts]

Hi

I have a report for repair estimates, part of the estimate is the make, model and type of car, this is concatenated in a query, using [Make]&Chr&[Model]&Chr(32)&[Type]
On my computer this works fine in the report, however on another computer I get a square between each of the fields when previewing and printing.
Can anyone advise what is the problem

thanks

Richard

 

[micks55]

I'm no specialist but could it be a font problem? Do both computers have the font installed? If not, you might try using plain old Arial?

 

[georgedwilkinson]

What is "Chr"?

 

[boblarson]

Instead of Chr(32) {which is a space} just use

" "

instead

so

[Make] & " " & [Model] & " " & [Type]

But just be aware that your field name Type has special meaning within Access and VBA and so you should probably not have a field (or object) named that.

 

[MSAccessRookie]

Instead of Chr(32) {which is a space} just use

" "

instead

so

[Make] & " " & [Model] & " " & [Type]

But just be aware that your field name Type has special meaning within Access and VBA and so you should probably not have a field (or object) named that.

Won't the Field MAKE have a similar issue?

 

[boblarson]

Won't the Field MAKE have a similar issue?

Make is not on the list of reserved words, at least that I can see. See here for a very comprehensive list:
http://www.allenbrowne.com/AppIssueBadWord.html

I can't think of anywhere that Make is used in a reserved sense. What context are you thinking of?

 

[rnutts]

Thanks for replies

Bob I have tried &" "& before still get the same problem
Micks55 The font is Arial 10
Also thanks for the tip on the reserved word

any other thoughts

Thanks

 

[georgedwilkinson]

I have a report for repair estimates, part of the estimate is the make, model and type of car, this is concatenated in a query, using [Make]&Chr&[Model]&Chr(32)&[Type]

Again, as I asked in post # 3, what is "Chr"?

 

[Velid]

Have you tried to concatenate in report instead in query??

Only other thing that I can think is field format in query. Did you change anything there? Can you do concatenation of any other fields?

 

[rnutts]

Chr is a typo here should have been chr(32) as per the second part of the string

 

[micks55]

Richard. Just in case it helps,
In the query screen I think I would use CarIs: [Make] & " " & [Model] & " " & [Type]
(make sure that [CarIs] is the control source for the control on the report)
or bring all three fields onto the report, hide them (visible=false) and use a seperate unbound field with ' = [Make] & " " & [Model] & " " & [Type] ' as the control source.
Mike - micks55(he wished)