Changing Date Format?

[SWFisherman]

I am working w/ a database that was designed by someone else. When the
database was originally designed, there were 3 DOB fields. One was formatted
99/99/9999 & the other two have the capability to pull from that if field if
they are the same person, or if it is a different person you can input the
date formatted 99/99/99.

The problem is when entering in the 99/99/99 format, everything defaults to
the 21st century (i.e. 01/01/2001 instead of 01/01/1901). I have tried going
into the design of the database table & changing the format to 99/99/9999 &
it accepts it, but when I run the database in normal mode, it still will only
take the 99/99/99 format & it gives me an error. I have even tried to
copy/paste the formating from the field that does not give me problems since
all three fields are in the same table & I get the same results.

Any ideas?

 

[Fred]

Depending on the other details, there might be a secondary issue which is how
a 2 digit year gets interpreted.

When you say running in "normal" mode, are yo referring to form views? If
so, you should check/ set the display format for the "box"

Also, in tools->Options -> general these is a general setting for this.

 

[Jerry Whittle]

Let me see if I have their right:
All three DOB fields are in the same table.
You only need to type in one then the other two automatically populate with
the correct data.

If that is correct, the something in a form, query, or code is automatically
updating the data in the other two fields. Something there is causing the
problem with entering the 4 digit dates. You'll need to figure out what is
updating the other two DOB fields in the table and fix that.

 

[SWFisherman]

The error message I get is:
"The value you entered isn't appropriate for the input mask '99/99/99'
specified for thies field"

The input mask on each of these fields is '99/99/9999' as clear as day in
design view.

Fred,
Yes, "normal" meant form view. To get into design view in the DB I have to
hold Shift while opening the DB. I tried checking the 'Use 4 digit year
formating' under tool->options->general but still get the same error message.

Jerry,
This is for a healthcare database. Yes, all three fields are in the same
table. You only need to type in one DOB if the Patient requesting service is
also the Insured. In the case where a child or spouse is the patient, then
the insured will be different. So basically the DOB in the insurance fields
(Primary & Secondary Insurance) are where the problem is. When they do pull
from the original Patient DOB there are no problems, the only problem is
manually inputing it when the insured DOB is different.

There is a single click button setup in the form to input the fields
automatically if the patient & insured are the same. I found where it
references the original information using Visual Basic & here is the formula
(DOB is on 8th line):

Private Sub Command228_Click()
Me.Refresh
txtPRel = "Self"
txtPFirst = txtFirst
txtPLast = txtLast
txtPMiddle = txtMiddle
txtPSSN = txtSSN
txtPDOB = txtDOB
Me.Refresh

End Sub

Now I just can't find where txtPDOB is defined to see if that is where the
problem lies.

P.S. Thank you both for your replies.

 

[Jerry Whittle]

"the other two have the capability to pull from that if field if they are the
same person"

What is this capability? How are the other two DOB fields populated?

If there is some fancy code or something, I think that your answer will be
found there.