take a look at the attachment. i wonder where did i gone wrong...
Printable View
take a look at the attachment. i wonder where did i gone wrong...
need to know more info:
Where is the data coming from? how are you getting it?
post code that loads those fields
The data comes from a table which consists of date fields.
VB Code:
Do Until rsKakitangan.EOF dtpDateOfBirth.Value = rsKakitangan!BirthDate & "" dtpDateOfIssueIC.Value = rsKakitangan!IC_IssueDate & "" dtpDateOfIssueCitizenship.Value = rsKakitangan!CitizenCertDate & "" dtpDateOfIssuePassport.Value = rsKakitangan!PassportIssueDate & "" rsKakitangan.MoveNext Loop rsKakitangan.Close Set rsKakitangan = Nothing
anything wrong there?
What is the format string you are using for those fields?
-tg
it's short date format for all those fields.
what if you tried:
dtpDateOfBirth.Value = Format(rsKakitangan!BirthDate,"mm/dd/yyyy")
im sorry to disappoint you guys. i just found that it was actually my staffs who entered invalid dates into the field such as 01/01/100 instead of 01/01/2001..
sorry again, my bad :(
case solved.