Simple format question

  • Thread starter Thread starter cind
  • Start date Start date
C

cind

Id rather not create any extra queries or funcitons, just
change the actual report in someway to make that change.

Cind
-----Original Message-----
-----Original Message-----
Hello,

Id like to change the value of a string when the report
is openened. Id like to change "0" to "N/A" (string
field).

Ive put an IF statement in the format event of the detail
section, but that doenst seem to work.

Any help would be appreciated,

Cind
.
You might want to try an IIf statement in a seperate
Click to expand...
query or in VB. I had a similar problem and created a
seperate query and referenced that for my reports.

Expr##: IIf(IsNull([Your referenced field]),"NA",[The
value of your referenced field])

Hope this helps

Michael
.
Click to expand...
 
I know what you mean. I'm pretty sure you can also do it
as an event proceedure. It is in the help under IIf.
Good luck.

Michael
-----Original Message-----
Id rather not create any extra queries or funcitons, just
change the actual report in someway to make that change.

Cind
-----Original Message-----
-----Original Message-----
Hello,

Id like to change the value of a string when the report
is openened. Id like to change "0" to "N/A" (string
field).

Ive put an IF statement in the format event of the detail
section, but that doenst seem to work.

Any help would be appreciated,

Cind
.
You might want to try an IIf statement in a seperate
Click to expand...
query or in VB. I had a similar problem and created a
seperate query and referenced that for my reports.

Expr##: IIf(IsNull([Your referenced field]),"NA",[The
value of your referenced field])

Hope this helps

Michael
.
Click to expand...
.
Click to expand...
 
Back
Top