Hello Everyone, I have tried everything I can to get the MarkUp field to show up as a percent after switching the Category. Starts off as 20.00% but shows up as 0.05, 0.75, or 0.80 depending on which product is selected. Is this just a bug in Access 2016 or am I missing something? Thanks Joe
It's tough to say what's wrong without seeing your database. Make sure you've got the value set up as a floating point number in the table (double, preferably) and then set the format as Percent. Remember the FORM's formatting will override anything in the table.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access SQL Seminar Part 2.
