Blank Currency Fields in Access
Posted on 2013-01-21
My database is doing something I can't workout - it's displaying blanks where there should be a currency value over £0. (yes it shows £0, but nothing else).
This is true if I am looking at a table or a form, and different ones.
Normally the database runs an autoexec macro that opens a form ("fil") that asks for the users name, the user clicks Continue and some further code runs that opens the main form and runs a make table query.
If I bypass the Autoexec I get two possible situations:
1) If I replicate the Autoexec by opening "fil" manually, the values still won't show
2) If I go straight to a table the values do show, and then if I replicate the Autoexec the values continue to show as they should.
Originally, this was an .mdb, but the .accdb does the same.
I'd be grateful for any advice to track down the problem.