How does "Percent" work in Format property of Number data type?

[sniffingvixen]

When I try to use the Percent format for a field, I can never enter the data I want.

If I enter a decimal, the field returns 0%. This happens no matter how many decimals are allowed.

If I enter a whole number (3), the field returns as expected according to the format description (300%).

I've asked everyone I know who works with Access (granted there aren't many) and scoured the embedded help and various on-line sources. No one that I asked uses this format, instead they format their percentages in forms and reports by concatenating.

I'm using Access 2003 on Windows XP. I've tried this in both file formats (2000 and 2002-2003).

Is there a patch for this? Or is there some option/property that I need to set?

Thanks in advance,
j

 

[traingamer]

What is your 'field size' for the field? If it is 'Integer' this would explain your problem.

Try changing it to 'Single' or 'Decimal' and see what results you get.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[IGPCS]

well you can try this

Format (FieldName, "Percent")

this should work correctly

I will try my best to help others so will others do!!!!!
IGPCS
Brooklyn, NY

 

[sniffingvixen]

Traingamer,
Doh! I can't believe I missed that. Nor can I believe two IT people in my company missed it!
Thanks a bunch,
j

IGPCS,
I didn't try your method since traingamer's worked, but thanks for the reply.
-j