Re: Use TBC in a date field

Collapse
This topic is closed.
X
X
 
  • Time
  • Show
Clear All
new posts
  • Stuart McCall

    Re: Use TBC in a date field

    <paulquinlan100 @hotmail.comwro te in message
    news:7f8a74a0-1769-4940-8c71-b51a17913cb5@r6 6g2000hsg.googl egroups.com...
    Sorry, i meant that with that format it would only accept null values?

    Paul

    On Jul 24, 2:24 pm, "paulquinlan... @hotmail.com"
    <paulquinlan... @hotmail.comwro te:
    Thanks Stuart
    >
    The problem, i have now is that when the user actually does type a
    date it says "the value you entered isnt valid for this field" and the
    only value it will accept is TBC.
    Yes, my bad, sorry. The format property should contain:

    mm/dd/yyyy;;;"TBC"

    (or whatever format you prefer for the first part)

    As regards typing in TBC, ignore my previous and just tell your users to
    either leave it blank, or, if you want to change a date into TBC, tell them
    to just delete the date value. When they tab away from the control, it will
    display TBC.


Working...