[RESOLVED] What the.. those characters!

[Kaine]

take a look at the attachment. i wonder where did i gone wrong...

[Static]

need to know more info:

Where is the data coming from? how are you getting it?
post code that loads those fields

[Kaine]

The data comes from a table which consists of date fields.

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?

[techgnome]

What is the format string you are using for those fields?

-tg

[Kaine]

it's short date format for all those fields.

[Static]

what if you tried:

dtpDateOfBirth.Value = Format(rsKakitangan!BirthDate,"mm/dd/yyyy")

[Kaine]

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.