FLJerseyBoy
Registered User.
- Local time
- Today, 08:50
- Joined
- Jul 27, 2018
- Messages
- 18
A simple form includes a text box holding a date/time field (on SQL Server back end, if that matters); the format explicitly set in the form design is "mm-dd-yyyy." It works exactly as expected... except on ONE user's computer. (And it only happens on that user's desktop, not his laptop!) On that computer, the field displays as if it were formatted "yyyy-mm-dd hh:nn:ss" (i.e., including the full time as well as the date).
At first I thought it must be just a simple Windows setting -- overriding the explicit format for some reason. But it happens only in this ONE control; I've got other date/time fields on the same form which behave as expected.
But there's one thing different about this control: it has conditional formatting (foreground/background colors) applied.
So my question is: does conditional formatting cause the control's Format property to be ignored?
TIA for any advice.
[EDIT TO ADD: but then again, why only on this one computer?!?]
At first I thought it must be just a simple Windows setting -- overriding the explicit format for some reason. But it happens only in this ONE control; I've got other date/time fields on the same form which behave as expected.
But there's one thing different about this control: it has conditional formatting (foreground/background colors) applied.
So my question is: does conditional formatting cause the control's Format property to be ignored?
TIA for any advice.
[EDIT TO ADD: but then again, why only on this one computer?!?]
Last edited: