I have MS Access 2000 and in my form I want to show the leading zeros in my text box. I've read this old thread:
thread702-1441155 which is similar but I only have 4 digits to worry about...such as 0123 0875 0046 etc etc
How do I get these zeros back in? Do I need to build an event such as this other thread? Do I just go to the Properties Format? Right now I have the format set as General Number.
I tried building an event like this:
format(MyField), "0000")
I'm sure this is incorrect.
Any help would be appreciated.
But while we're on the subject of numbers....
I posted a thread awhile back with no answers. I was able to create a hyperlink to websites in this same form and the hyperlinks work however they display such as 00000/00000.0000 etc etc Lots of zeros. Can't figure out why. Where it says how to display is correct such as but viewing them in the form is weird. I wasn't too concerned since the links work but it's distracting.
Thank you again for any help.
thread702-1441155 which is similar but I only have 4 digits to worry about...such as 0123 0875 0046 etc etc
How do I get these zeros back in? Do I need to build an event such as this other thread? Do I just go to the Properties Format? Right now I have the format set as General Number.
I tried building an event like this:
format(MyField), "0000")
I'm sure this is incorrect.
Any help would be appreciated.
But while we're on the subject of numbers....
I posted a thread awhile back with no answers. I was able to create a hyperlink to websites in this same form and the hyperlinks work however they display such as 00000/00000.0000 etc etc Lots of zeros. Can't figure out why. Where it says how to display is correct such as but viewing them in the form is weird. I wasn't too concerned since the links work but it's distracting.
Thank you again for any help.