Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / Visual Studio.NET / General / October 2006

Tip: Looking for answers? Try searching our database.

NULL dates show today's date rather than a blank or NULL on form

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
M Skabialka - 30 Oct 2006 18:22 GMT
I am creating my first Visual Studio project.  I have created a form and
used written directions to add data from a table to the form using table
adapters, data sets, etc.
I imported a table from an Access database which has some date fields.  Many
of these dates have never been filled in, so are nulls.  If I look directly
into the table data it shows NULL.
However, when I scroll from record to record on the form, any date field
which should be NULL shows today's date, though it doesn't change it to that
date (thank goodness!).
How can I change the property on this field to show a blank or the word NULL
rather than today's date?  Which property is this, and where?  The form, the
table, the TableAdapter???  As I said, I am new to Visual Studio,
experienced in Access.

Thanks,
Mich
M Skabialka - 30 Oct 2006 18:43 GMT
Each date field has also been created as a calendar drop-down box - is this
why there is a default date of today?  I would rather show NULL, e.g. one of
the dates is a disposal date, and the item is not disposed of yet.

>I am creating my first Visual Studio project.  I have created a form and
>used written directions to add data from a table to the form using table
[quoted text clipped - 12 lines]
> Thanks,
> Mich

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.