By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
454,105 Members | 1,018 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 454,105 IT Pros & Developers. It's quick & easy.

format : %

P: n/a
When I open a table and select one of the item format to %, when I
input data it will mulitple by 100 (eg. input "2" and result come out
to "200%", input "0.2" and result come out to "0"),please advise how
to do it?
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Apple wrote:
When I open a table and select one of the item format to %, when I
input data it will mulitple by 100 (eg. input "2" and result come out
to "200%", input "0.2" and result come out to "0"),please advise how
to do it?


That's what the % format does. You can use an afterupdate event for the
textbox to get it to behave as if Microsoft came from this planet...

Sub MyPercentage_AfterUpdate()
If MyPercentage > 1 Then
MyPercentage = MyPercentage / 100
End If
End Sub

--
This sig left intentionally blank
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.