Solved

empty date field in the datagrid

Posted on 2003-12-11
6
292 Views
Last Modified: 2010-05-03
I have a column in SQL database table with date datatype. If user does not enter date in this field adding a new record the datagrid displays 1/1/1900. How can I avoid this and display an empty cell? Please, help.
0
Comment
Question by:Marinasout
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
6 Comments
 
LVL 1

Accepted Solution

by:
bladefist earned 250 total points
ID: 9923854
maybe your database puts that date as a default. Visual Basic wouldnt just randomly do that. Check your database metadata
0
 
LVL 8

Expert Comment

by:ampapa
ID: 9924463
Are you sure the field is empty? The field should be NULL if it is truly empty. It looks like something is being added to the record as indicated by what usually is an invalid date "1/1/1900"?
0
 

Author Comment

by:Marinasout
ID: 9927921
Hi, bladefist
you area right. Database puts that date as default. How can I check metadata?
0
 
LVL 27

Expert Comment

by:planocz
ID: 10270565
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:
No response from Marinasout from 12/12/2003 comment
Award points to bladefist is recommend.
Please leave any comments here within the next seven days.
PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

planocz
EE Cleanup Volunteer
0
 

Author Comment

by:Marinasout
ID: 10372140
Yes, the field was NULL and in this case it shows 1/1/1900. To avoid this i added requird field validator. Thank you. I accepted the answer.
0

Featured Post

Instantly Create Instructional Tutorials

Contextual Guidance at the moment of need helps your employees adopt to new software or processes instantly. Boost knowledge retention and employee engagement step-by-step with one easy solution.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When trying to find the cause of a problem in VBA or VB6 it's often valuable to know what procedures were executed prior to the error. You can use the Call Stack for that but it is often inadequate because it may show procedures you aren't intereste…
Enums (shorthand for ‘enumerations’) are not often used by programmers but they can be quite valuable when they are.  What are they? An Enum is just a type of variable like a string or an Integer, but in this case one that you create that contains…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

734 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question