Search results

Sadly it's out of my hands, every number has to start 410-1-_____ with the final 4 numbers being unique and matched to a form from another system. If there isn't a way to have Access ignore the first occurence of 0, then I'll have to take it out but was hoping there would be.

Hi, sorry to ask what might be a stupid question but I am trying to create an input mask that starts 410-1-______, it's an invoice number that has 4 digits that remain the same at the start (one of those numbers being a 0) - however, I know Access treats a 0 as an indicator for input. Is there...