The title almost says it all...I have a textbox bound to a character field in a table containing times, like "12:00". So, I bind a textbox to this field with an input mask of "99:99" (why make the user type a colon?). Everything works great. But now I have decided that instead of storing just "1200" in the database (which it does since the colon is not part of the textbox's Value property) I would like to store the colon for using the data later (instead of always having to TRASFORM() it before use.
How can I make the textbox send the TEXT property to its bound field instead of VALUE. Am I missing a property somewhere that controls what goes back to the field? Or is this all just by design and I either have to make the user type the colon or leave it out of the database? I can think of a lot of reasons to send the formatted data back to the database, the most prevalent one being that if I want to do a COPY TO...FILE out of the data table, I have no control over masking the data, and would definitely want the colon to be in there (that's just one example).
Any and all help would be greatly appreciated...
Thanks,
Joe Kaufman
jkaufman@encompas.com