Question on formatting percent field

[ddean68]

Hi everyone,

I am doing a form that requires quite a few percent fields. What I wish to happen is if I type in 50 it would display 50% atm though it is displaying 5000%. I know the reson why this is happening, however I wish to get it so it works in the way I stated above. So that 50 = 50% not 5000 . is this possible?

 

[SgtJarrow]

afterupdate event of control:

Me![controlname] = (Me![controlname]/100)

****************************
People think it must be fun to be a super genius, but they don't realize how hard it is to put up with all the idiots in the world. (Calvin from Calvin And Hobbs)

Robert L. Johnson III
MCSA, CNA, Net+, A+
w: rljohnso@stewart.com
h: wildmage@tampabay.rr.com

 

[CajunCenturion]

I'm guessing that you're using the format function, since an automatic mutiplication is taking place?

You might want to consider, instead of using the Format function, simply a string concatenation:

=Trim(TheValue) & "%"

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein