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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

formatting a function 2
Access Test if value is less than percent 0
Access Group by precinct, calculate percentage of older voters 0
Calculate percentage 2
Excel How to calculate percentage for time 1
Calculating Percentages Using a Query 3
Percentage Change 2
User Select Top Value Percentage 8

Back
Top