Format number field to show Percent

[Kaylen]

The code works! Thank you Clifford!

Hi Kaylen,

Try this instead:

If Not IsNull(controlname) And Right(controlname, 1) <> "%" Then
controlname = controlname / 100
End If

Clifford Bass

 

[John W. Vinson]

With Access 2007 I believe all you have to do is set the control's Format
property to Percent.

That is what I had not realized. That certainly makes it simpler than my
suggestion!

 

[Kaylen]

Thank you for everyone' s help and suggestions. I am able to format the
number to Percent the way I would like to! Thank you all for being so helpful!

 

[Clifford Bass]

Hi Kaylen,

You are welcome!

Clifford Bass