Expressions on Reports

[Don Whitaker]

I am using Accss 2000 to create a report, but I can't
seem to use expressions on my report to any degree of
luck. My report runs off of a query. It looks like
anything that I want a function on or calculate I have to
do it in the query and not in the report on the control
source property. Is that right or am I missing something.
It looks like I cannot use =[PayType] to display a field
on the report?
When I use =[PayType] I get an #Error the function I'm
trying use is UCase I thought the expression should be
=UCase([PayType]), but all I get is #Error, now when I
put in the query expPType:Ucase([PayType]) it works fine?

I am also trying to do minor formatting and string
concatenation, but I guess I have to do it in the query?
Any advice is appreciated. Thanks, DW

 

[Allen Browne]

Try changing the Name of the text box (Other tab of Properties box) when you
change the ControlSource.

Access gets confused if the control has the same Name as a field, but is
bound to something else.

 

[Don Whitaker]

Thank You Very Much !!!!
I was very frustrated.

-----Original Message-----
Try changing the Name of the text box (Other tab of Properties box) when you
change the ControlSource.

Access gets confused if the control has the same Name as a field, but is
bound to something else.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I am using Accss 2000 to create a report, but I can't
seem to use expressions on my report to any degree of
luck. My report runs off of a query. It looks like
anything that I want a function on or calculate I have to
do it in the query and not in the report on the control
source property. Is that right or am I missing something.
It looks like I cannot use =[PayType] to display a field
on the report?
When I use =[PayType] I get an #Error the function I'm
trying use is UCase I thought the expression should be
=UCase([PayType]), but all I get is #Error, now when I
put in the query expPType:Ucase([PayType]) it works fine?

I am also trying to do minor formatting and string
concatenation, but I guess I have to do it in the query?
Any advice is appreciated. Thanks, DW

.