Search results

If you always want 5 chars and Me!txtRefNumber is less than 10000 a simple solution would be :- Right("0000" & Me!txtRefNumber, 5)

Thanks, much appreciated.

I'll have a word with Mr Musk about putting in a Hyperloop under the pond 🤣

I suspect you get a bit more sun than us as well! It's very pretty over here though....

Great forum Been developing Access applications for over 20 years now on a commercial basis for SME clients in the apparel & fashion industry. My small company is based in the UK in Snetterton, Norfolk. We have 3 devs and 3 support staff and have been trying to recruit programmers with...