Eric Barro
ebarro at afsweb.com
Wed Nov 17 11:04:34 CST 2004
Karen, This should work... MyFormControl.Text = FormatDateTime(MyRecordSetField, DateFormat.ShortDate) Eric -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com]On Behalf Of Nicholson, Karen Sent: Wednesday, November 17, 2004 7:01 AM To: dba-VB at databaseadvisors.com Subject: [dba-VB] VB.Net Format Bound Date Fields Begging for help... I can't seem to get a straight answer on this. I have a windows form, vb.net, with a bound date/time field named accdate. The format is SQL server is short date. When I generate the dataset, the format is short date. When I place the bound field on the data entry form, it appears as short date with all the time information as well. How do I change the bound field on the form to display the normal old short date format? This seems nuts. _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com ---------------------------------------------------------------- The information contained in this e-mail message and any file, document, previous e-mail message and/or attachment transmitted herewith is confidential and may be legally privileged. It is intended solely for the private use of the addressee and must not be disclosed to or used by anyone other than the addressee. If you receive this transmission by error, please immediately notify the sender by reply e-mail and destroy the original transmission and its attachments without reading or saving it in any manner. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that any disclosure, copying, distribution or use of any of the information contained in or attached to this transmission is STRICTLY PROHIBITED. E-mail transmission cannot be guaranteed to be secure or error free as information could be intercepted, corrupted, lost, destroyed, arrive late or incomplete, or contain viruses. The sender therefore does not accept liability for any errors or omissions in the contents of this message, which arise as a result of email transmission. Users and employees of the e-mail system are expressly required not to make defamatory statements and not to infringe or authorize any infringement of copyright or any other legal right by email communications. Any such communication is contrary to company policy. The company will not accept any liability in respect of such communication.