dates does not show in proper format

[chubbychub]

i have a table in the column , i want it to show month and year only
like this: 06/24
06 being the month, and 24 being the year
but it shows as 62/4 or 624
and for october, november and december ..when we enter data, we enter it with 4 digits number, but for the rest of the month, we just enter 3 digits ..being only month and year
please see attachment, thanks in advance.

[ranman256]

you can set the FORMAT in query column property: mm/yy
or
force it as: format([dateFld],"mm/yy")

[Bob Fitz]

i have a table in the column , i want it to show month and year only
like this: 06/24
06 being the month, and 24 being the year
but it shows as 62/4 or 624
and for october, november and december ..when we enter data, we enter it with 4 digits number, but for the rest of the month, we just enter 3 digits ..being only month and year
please see attachment, thanks in advance.

Where are there any records that have a forward slash "/" ?
All I see is one table with one field of short text type

[chubbychub]

but how do i do that? can you please do it for me so i can see how it works? please

[mike60smart]

Hi

It would help when you create a field which is a Date Field that you actually make the DataType a Date/Time rather than Text.

In the attached I created a Form based on your table and as Ranman suggested just Format the Date Field.

I only did a few of the records rather than the whole 900+

[Bob Fitz]

Hi

It would help when you create a field which is a Date Field that you actually make the DataType a Date/Time rather than Text.

In the attached I created a Form based on your table and as Ranman suggested just Format the Date Field.

I only did a few of the records rather than the whole 900+

Not sure that will fulfil the OP's requirement from post #1

and for october, november and december ..when we enter data, we enter it with 4 digits number, but for the rest of the month, we just enter 3 digits ..being only month and year

[Bob Fitz]

i have a table in the column , i want it to show month and year only
like this: 06/24
06 being the month, and 24 being the year
but it shows as 62/4 or 624
and for october, november and december ..when we enter data, we enter it with 4 digits number, but for the rest of the month, we just enter 3 digits ..being only month and year
please see attachment, thanks in advance.

You should be using a form to edit data rather than a table which should be used just for data storage.
In the attached db I have created a form which will enable you to enter 0122 and get 01/22 or enter 122 and get 1/22
The changes are made in the AfterUpdate event of the textbox.

[chubbychub]

Thank you mike60smart, that what i need. Is there a tutorial or link you can point at on how to do that? or instructions? please.
I have a column with data already and macros running on respective columns, ( and i dont know what is relevant and what is not relevant as i am very limited with what i know with access)
I have it in a column, and only need somethign simple, but not sure how to go about it.

[chubbychub]

thank you bob fitz and mike60smart and ranman256! i found a tutorial and got it. thread marked as solved and rep added!