Force Percentage Form

  • Thread starter Thread starter stickandrock
  • Start date Start date
S

stickandrock

I have a column on query that calculates a percentage.

When I set the format on the column to a percentage it seems to work fine,
but once in a while it will display as a full number and not as a percentage.
is the a way in the calculation to force this format....


Thanks
 
stickandrock said:
I have a column on query that calculates a percentage.

When I set the format on the column to a percentage it seems to work fine,
but once in a while it will display as a full number and not as a percentage.
is the a way in the calculation to force this format....
Click to expand...


Formatting a query is near useless. Formats only need to be
specified in for/report text boxes where users will see it.

You can try setting the Format property to 0% or 0.0% or ...

Note that Access often (depending on what will fit in the
available space) will display the full number when it has
the focus. This is so users can edit the real data instead
of some potentially arbitrary representation of the data.
 
Back
Top