[RESOLVED] What the.. those characters!

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.