how change value in report source before printing ??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I need to round a number coming in my query before it is printe
in the FORMAT event I have tried everything to do this and I always get a message "you can't change this object". HELP
I've trie
Me.txtDays
Me!txtDays
txtDays
[txtDays] =

all have failed........
 
Cannot do such things in reports. Do the rounding in the query itself, or
use a textbox on the report whose control source is something like this:
=Round([FieldName], 2)

Be sure that FieldName is bound to a hidden textbox on the report as well.
--
Ken Snell
<MS ACCESS MVP>


--
Ken Snell
<MS ACCESS MVP>

David said:
I need to round a number coming in my query before it is printed
in the FORMAT event I have tried everything to do this and I always get a
Click to expand...
message "you can't change this object". HELP!
I've tried
Me.txtDays =
Me!txtDays =
txtDays =
[txtDays] =

all have failed........
Click to expand...
 
Back
Top