Format issues with Unbound control on a report

[Guest]

MS Access 2000, Windows XP
======================

Hi,

I have an unbound control (ControlC) on a report that has the following in
the control source:
=([ControlA]/[ControlB]). All the 3 controls are of the format "General
Number", and the Decimal Places set to 0 for ControlA and ControlB, and 2 for
ControlC.

When I run the report, ControlC displays the calculation more than 2 decimal
places, in some cases, up to 6 or 8.

I'm not sure what I'm doing wrong, and will appreciate a pointer in the
right direction. I'd like to display the number in ControlC to not more than
2 decimal places.

Thanks.

-Amit

 

[Duane Hookom]

Try change the format to "Standard". If that doesn't work, try change the
control source to:
=Val([ControlA]/[ControlB])

 

[Guest]

Hi Duane,

Thanks for the response. That worked.
Another solution that I found is to put "##.00" in the format, but I'm sure
you know that.

Thanks!

-Amit

Try change the format to "Standard". If that doesn't work, try change the
control source to:
=Val([ControlA]/[ControlB])

--
Duane Hookom
MS Access MVP
--

MS Access 2000, Windows XP
======================

Hi,

I have an unbound control (ControlC) on a report that has the following in
the control source:
=([ControlA]/[ControlB]). All the 3 controls are of the format "General
Number", and the Decimal Places set to 0 for ControlA and ControlB, and 2
for
ControlC.

When I run the report, ControlC displays the calculation more than 2
decimal
places, in some cases, up to 6 or 8.

I'm not sure what I'm doing wrong, and will appreciate a pointer in the
right direction. I'd like to display the number in ControlC to not more
than
2 decimal places.

Thanks.

-Amit