Trying to format a percentage

[Huddle]

For some reason, I have been unable to format a number to a percentage in either the form or query properties. I found this format formula on another site, however I only want 0 decimals i.e. 50% not 50.00%



Is there a way to use the formula and get 0 decimals??

PctWTMD: Format(IIf([WTMD_Totals]=0,"-",[WTMD_PMI_Complete]/[WTMD_Totals]),"Percent")

[Micron]

You posted in forms forum, but what you posted looks like a query calculated field so I'm answering based on that.
Can't see any sample values, but how about replacing "Percent" with a single zero?

[June7]

You can concatenate the % character.

Format function results in a text string, not a number. If you need to do further calculations with this value, do not use Format() function.

[Micron]

Or wrap Format in Cint or Clng etc.

[Welshgasman]

Or use Round() even?

[June7]

Wrapping Format using "Percent" with CInt or CLng fails with type mismatch. Could use Val().

[Micron]

Well, I did say to use 0 and not Percent?

[June7]

And then data is not presented as a percentage. I avoid formatting in queries. Apply format in textbox properties.

I've never used the Percent Format setting in table but maybe that would work for OP.

[CJ_London]

I would forget about trying to format in your query - the format function will convert it to a string and the format property won't carry forward to the form, just use the format property of the form control - put

0%;-0%;-

and set decimals to 0

change your formula in your query to

PctWTMD: [WTMD_PMI_Complete]/[WTMD_Totals]

or just include the calculation as the controlsource to your form

[Huddle]

I would forget about trying to format in your query - the format function will convert it to a string and the format property won't carry forward to the form, just use the format property of the form control - put

0%;-0%;-

and set decimals to 0

change your formula in your query to

PctWTMD: [WTMD_PMI_Complete]/[WTMD_Totals]

or just include the calculation as the controlsource to your form

This is how I normally do it, but my format is grayed out. Do you know what could be causing that problem?

[June7]

What do you mean by 'format is grayed out' - grayed out where? Certainly not on the Property Sheet?

[Huddle]

I figured it out. I just had to multiply by 1 in an underlying query. Seems to be working now. Thanks.