=IIf([TierFactor]1,[TierFactor],FormatCurrency([TierFactor],2))
works if textbox formated to format percent and decimalplaces set to 3
however formatpercent(tierfactor,3,1,1) doesn't work as described and
defined it yields an error
http://msdn.microsoft.com/library/de...afctformat.asp
however formatpercent(tierfactor,3,true,true) does
am i misinterpreting the linked information??? on formatpercent???
--
Jim
"Duane Hookom" wrote:
You can check Help for possibilities using the format function. If your
control source uses the Format() function then your Format Property is
in-effective.
--
Duane Hookom
Microsoft Access MVP
"JASelep" wrote:
This helped, Thanks!
If I wanted the percent sign to show with 3 decimal places VS currency with
2 decimal places, how would I format that or would I use a combination of
field format and controlsource defined format functions?
--
Jim
"Duane Hookom" wrote:
You should be able to set a control source like:
=IIf([Jim]1,Format([Jim],"0.00"),Format([Jim],"0"))
--
Duane Hookom
Microsoft Access MVP
"JASelep" wrote:
I have a report that uses one area to display either a percentage or a count
I'd like to format the report field output so that if the value is less than
1 to format the number as a 2 decimal point percent and if it is 1 or greater
format it as an integer
the conditional formatting features I see deal with the conditional display
format and not the conditional numeric formatting
I've struggled to see if I could conditionally format the data at the
ControlSource point of the field properties or at the format point but have
hit deadends on both avenues
Jim-