I just installed a split database on a non-profit organization's computer. In a table that contains date fields, I had set the date format to "m/d/yy" when defining the table fields on my computer. When I subsequently designed the input forms for the table, the dates show correctly in that format.
But when I installed the database on the client's computer, the dates show in "m/d/yyyy" format. I thought it might be because that computer's Regional Date Options were set to that format. However, I just experimented on my computer, changing the Regional Date format to "m/d/yyyy", then opening the database to see if the Regional format overrode the format defined in the table. It does not.
So. . . any idea why despite the date format being defined in the table as "m/d/yy" that on the client's computer, it displays as "m/d/yyyy"?
I have experienced exactly the same problem, the format has to be on the Form as well as the Table. That should make it show up OK for the Users of the Form.
I have experienced exactly the same problem, the format has to be on the Form as well as the Table. That should make it show up OK for the Users of the Form.
Hi, OBP; long time no talk to. How are things in Wales?
Don't think that's the problem, because the table was designed before the form, so when the fields were put on the form, they take the format from the table. I checked the form on my computer, and it does indeed show the format as "m/d/yy". I copied both the client and server sides of the split database directly from my computer to theirs, but it is nonetheless displaying "m/d/yyyy".
Cold here in Wales (for us anyway).
Have you tried putting an Input Mask on the form field to see if that has any effect?
I suppose you could use VBA to display the data correctly, but you shouldn't have to.
I have not tried using an input mask and can't do that until I visit their office again. . . because everything works as it should on my computer, just not on theirs.
The data source is not a query; it's just the table, since the form uses every field in the table.
Yeah, I could, but I'd have to do it on their computer to see if it makes a difference. Don't know when I'll be there again. Might be as early as end of this week, because things like this bug the sh** out of me, so I'm anxious to find out why it's doing what it's doing.
Status
Not open for further replies.
You have insufficient privileges to reply here.
Related Threads
?
?
?
?
?
Tech Support Guy
9.9M posts
859.7K members
Since 1998
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!