1) Thanks for all of the repsonses, i really appreciate it! 2) I got it. For some reason, a few tables had the initial fields set to Number. I changed them all to short text and all is well.
No. My report is showing a 0 when i want it to be blank. The form has a drop-down combo box and when you leave it set to "blank", it passes a '0' to the report for some reason. Does that make sense? I would never want a '0' in the report since the fields are for name initials.
It's actually the same field in 3 different spots on the report, so i'm sorry...not really 3 different fields. One of the fields in the table that is getting queried is an Auto number data type. Not sure if that has anything to do with it.
I tried that and still no luck. It indeed does not happen in the 2002 version of the database. This is driving me crazy! What would have changed that would make the form pass the 0? It doesn't do it for some of other combo box fields, just 3 of them. There must be a parameter i'm missing.
After a MS Access Database was upgraded to 2016, a user has been experiencing an issue when launching the report preview from a form. For some reason, a '0' value is getting passed to the report even when you leave the combo box selection set to blank. This never happened in the previous...