I am attempting to recreate the database on Beginner Level 1 series and have hit a snag. In the field that says Discount Rate, I enter a percentage and tab over only to see a zero in the field. Also I cannot see any options in Design View for numbers other than Long Integer. The dropdown box is completely blank to where I cannot see any options, including Long Integer. I am using Access 2016 and the training vid is 2013. Not sure if this matters or not. Any ideas on what the issue may be AND how to correct it please respond. I don't want to get messed up down the road by overlooking this on the front end.

---

Reply from Alex Hedley:

Can you change the Type in the Sample Db?
If you delete the Field and re-add it are all the options there?