Search results

Thank you D-Fresh, but before I try it. . . What property were you referring to being "set?" Also, do I put the expression in the expression builder or VB (or SQL)? Lastly, since the data (Date/Time) is going to display in one field, how could I use two seperate functions (one for date and one...

I have a table with a text field titled ID. The values in this field are typed in by the user and are supposed to be in the format mmddyyhhmm. There are values in the field like 0000003271 and 0000000001. I don't know how this could be, but how do I change these values into an understandable...