On Mon, 08 Sep 2003 19:29:05 GMT in comp.databases.ms-access, "Ralph"
<rm*****@earthlink.net> wrote:
A field in a table will contain values something like 5.0% or 6.1%. What do I
enter into the Format property for that field in the table so when I enter 6.1
it becomes 6.1% and not 610%?
This is something to make life simpler, for 6.1% you actually store
the value 0.061, this saves you the almighty task of diving by 100
when calculating the percentage value. Not much you can do in a table
but in a form if you know you'll never need more than 100% then this
simple AfterUpdate procedure will do the trick.
(air code)
Sub MyTextBox_AfterUpdate()
if MyTextBox > 1 then
MyTextBox = MyTextBox / 100
end if
End Sub
--
A)bort, R)etry, I)nfluence with large hammer.
(replace sithlord with trevor for email)