M
mcnews
how do i keep dd/mm/yyyy integrity when my mdb resides on african PCs.
tia,
mcnewsxp
tia,
mcnewsxp
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
John W. Vinson
how do i keep dd/mm/yyyy integrity when my mdb resides on african PCs.
tia,
mcnewsxp
You can set the Format property of any Form or Report textbox to dd/mm/yyyy.
You may be able to use API calls to change the computer's default date
setting... but your users may end up very annoyed with you if you do so! This
would affect all programs, not just Access.
Be aware that the date stored in the table is stored as a Double number count
of days and fractions of a day; it's not actually stored with any particular
format.
John W. Vinson [MVP]
M
mcnews
the users are in africa.You can set the Format property of any Form or Report textbox to dd/mm/yyyy.
You may be able to use API calls to change the computer's default date
setting... but your users may end up very annoyed with you if you do so! This
would affect all programs, not just Access.
Be aware that the date stored in the table is stored as a Double number count
of days and fractions of a day; it's not actually stored with any particular
format.
they want the date that way in everyting.
so i do i set the format on the form?
that is what i am asking.
J
John W. Vinson
the users are in africa.
they want the date that way in everyting.
so i do i set the format on the form?
that is what i am asking.
If they want the format on "everything" then set the format on "everything". A
Form doesn't have a format, but textboxes on a form do; likewise textboxes on
a report. You can also set the Format property of the fields in your Tables.
If the users in Africa will be developing their own forms or reports, they
will have to know and understand how date formats work. In particular, they
will need to be aware that queries searching on literal dates will REQUIRE
either the American month/day/year format, or an unambiguous format such as
yyyy-mm-dd or yyyy-mmm-dd.
John W. Vinson [MVP]
S
Steve Hayes
You can set the Format property of any Form or Report textbox to dd/mm/yyyy.
You may be able to use API calls to change the computer's default date
setting... but your users may end up very annoyed with you if you do so! This
would affect all programs, not just Access.
Be aware that the date stored in the table is stored as a Double number count
of days and fractions of a day; it's not actually stored with any particular
format.
My computer is African and I had problems with one of the Access templates
(for club membership).
I tried to enter a person born on 1 Jan 1926 and Access insisted that she was
born on 1 Jan 2026, and any attempt to correct it resulted in an invalid date
error message.
J
John W. Vinson
My computer is African and I had problems with one of the Access templates
(for club membership).
I tried to enter a person born on 1 Jan 1926 and Access insisted that she was
born on 1 Jan 2026, and any attempt to correct it resulted in an invalid date
error message.
Were you using a four digit year, or two digit? Any two digit year by default
is treated as being in the 21st century if it's 00 through 29, and the 20th
century for 30 through 99.
You may be able to change this by using Tools... Options to set the database
to use four digit years throughout.
John W. Vinson [MVP]
M
mcnews
If they want the format on "everything" then set the format on "everything". A
Form doesn't have a format, but textboxes on a form do; likewise textboxes on
a report. You can also set the Format property of the fields in your Tables.
If the users in Africa will be developing their own forms or reports, they
will have to know and understand how date formats work. In particular, they
will need to be aware that queries searching on literal dates will REQUIRE
either the American month/day/year format, or an unambiguous format such as
yyyy-mm-dd or yyyy-mmm-dd.
i'm sorry, but you still haven't answered the question.
please don't fill in any more assumptions and please tell be how to
set the format on a textbox.
i know about the Format(string, "dd/mm/yyyy") function. i tried that
with after update. no go.
i don't see an edit mask i can use.
their computers use dd-mm-yyyy format by default, but Access is
flipping the dates to american format.
J
John W. Vinson
i'm sorry, but you still haven't answered the question.
please don't fill in any more assumptions and please tell be how to
set the format on a textbox.
Open the Form in design view.
Select View... Properties on the menu.
Mouse click on the textbox.
In the properties window click on the Format tab.
The first row of those properties is the Format property.
Type the following characters into the property textbox:
dd/mm/yyyy
Save the form.
John W. Vinson [MVP]
M
mcnews
Open the Form in design view.
Select View... Properties on the menu.
Mouse click on the textbox.
In the properties window click on the Format tab.
The first row of those properties is the Format property.
Type the following characters into the property textbox:
dd/mm/yyyy
Save the form.
it works.
whew....!
thanks.
S
Steve Hayes
Were you using a four digit year, or two digit? Any two digit year by default
is treated as being in the 21st century if it's 00 through 29, and the 20th
century for 30 through 99.
You may be able to change this by using Tools... Options to set the database
to use four digit years throughout.
Yes, I normally use four digit years and try to set that as the default in all
programs.
Ask a Question
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.