Recent content by ms2000

Ok, I changed the table to a date/time data type. Then I added the expression to display just the first three letters of each month...worked beautifully. Now, in the form, I am running into issues with Data Type Mismatch when I use the A->Z sort button... I want the 3-letter month to display...

Thank you. I'm a bit of an idiot. Where exactly does that code go? And what is "NewFieldNameHere" mean? In my table, I have two fields, one is the MonthID and the other is the Month1 (now a date/time data type). In the field properties under Format, I've tried to enter the code, but it...

I know....I was thinking the same thing...I can change the date field as I am just finishing the design of the db, so there is not much data in there yet. If I choose date/time as my data type, what is the code to just show the 3-letter month? I tried a few things, but it didn't work. Also...

Hi, I set up a table with a text field (Month1) for a three-letter month. (Jan, Feb, etc.) In a continuous list form, I want to be able to click the A->Z sort button in the toolbar and have the dates sorted by chrono. I use the A->Z sort button for several other fields in the form as well...