Thanks, Sean, for your advice. However, I have fiddled around with different combinations - Single, Double (with Percentage format), along with different combinations of decimal points, etc.
The problem now is that, despite editing the field formats in table design view and then delete and re-inserting the field into my form, every percentage I enter into the field converts to something like the following: 13.75 = 1375.00 14 = 1400.00 ...and so on. Would I be best to delete the field completely and start again, or is there another way to fix this problem? Any help would be much appreciated. --- In [email protected], "Sean" <[EMAIL PROTECTED]> wrote: > > When you were working on this field did you adjust the Field Size > when you are in design mode. I find that if it is set to "Single" > or "Double" that it works best. You would still need to set format > to Percentage. > > Sean > > --- In [email protected], "karasmith1988" <innerfairy@> > wrote: > > > > Just a strange little question regarding the Percentage field > format. > > My commission rate field is set to Percentage, but if I enter, for > > example: > > > > 13.75, it converts back to 0.00%. The weird thing is that prior to > > this, it was converting 13.75 to 1400.00%, and 15 to 1500.00%. > > > > Any suggestions for fixing this? Thanks! > > > Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
