Problem entering percentages in a form

[50Bucker]

When ever I enter a percentage in a field on my form, it returns to 0 as soon as I tab out of the field. What am I doing wrong? I'm trying to use percentages in functions elsewhere on the form.

[TG_W]

The field in your form should be formatted to Percent in the 'Format' section of the 'Format' tab in the 'Property Sheet'. See if that helps.

[50Bucker]

The field in your form should be formatted to Percent in the 'Format' section of the 'Format' tab in the 'Property Sheet'. See if that helps.

I've got that part, but when I enter the number, it initially shows as a percentage, but when I tab out of the field it returns the value to "0". If I remove the percentage format and just enter the number in as a decimal, the same thing happens. All of the functions in the form work fine when this number is set to anything above "1". Any thoughts?

[TG_W]

What is the property of the Field in the source Table? It should be 'Single' or 'Double' and "Format" should be 'Percent'

[50Bucker]

Thank you! yes, this solved the problem.

[TG_W]

Great! Happy I could help. Please mark the thread as "Solved" at the top under 'Thread Tools'.