Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When fields in my form are unbound, they appear correctly: they are formatted
as percents and appear as percents. However, as soon as I input the control
source table, they no longer appear as percents (and don't appear if too
small, i.e. automatically revert to zero.) How can I make the entires appear
as percents on my form and still be bound to my table?
 
I've done that in both the form field properties and the table properties
that the field is bound to. Is there something else?
 
Without it in front of me to tinker with, I don't know. Is the value in the
field a decimal percentage like .01 or is the the value 1?
 
i've been inputing them as decimals but changing that to a whole number
doesn't seem to fix the problem.
 
Try removing the formatting from the table field and leaving in on the form.
You also have to deal with the issue that when the user enters info, to get
10%, they have enter .1 Entering 1 will evaluate to 100%. The data type for
the field must be either Single or Double since you will be dealing with Non
Integer numbers.
 
Thanks...needed to change to single.

Klatuu said:
Try removing the formatting from the table field and leaving in on the form.
You also have to deal with the issue that when the user enters info, to get
10%, they have enter .1 Entering 1 will evaluate to 100%. The data type for
the field must be either Single or Double since you will be dealing with Non
Integer numbers.
Click to expand...
 
Oh, good. Remember, Integer and Long Integer data types are for whole
numbers only.

Do others a favor and rate the post so when they have a similar question, it
will show up in their search.
 
Back
Top