Hi,

I need to change the way some date data is shown in access. It has been provided as a text field.

I currently have date ranges shown as yyyymm. I need to see it as 01/mm/dddd (currently have no "dd", therefore need to add a 01 at the beginning to get what I need).

Is there a way I can do this? Maybe in the input mask or expression build?

Thanks

Jigna

Dear Jigna

Thank you for attending Access Intermediate course. I hope that you enjoyed the course.

I am not sure if you mean to say that the field that the date appears on has got a Text data type in the design view.

Please ensure that field has Date/Time data type and then choose the short date from the Field properties at the bottom part of the design view of the table.

If you want the user to follow the specific format then simply type in 99/99/00;0 in the input mask box just below the format box.

Just for your information:
9 is for any digit or space which is not mandatory
0 is for digit and is manadatory
/ is the literal character that is normally used for separating days, months and years in a data/time format
;0 means that you want the literal character to be displayed in the filed when the user starts entering data. If you leave it blank or use ;1 then the literal “/” in this case will not be displayed!!

Tip:

If you would like the to know more abut the input mask characters simply place the cursor anywhere in the input mask filed in the field properties section and press F1 on the keyboard. If will give you the help window which will give you examples and also explanation of various another input masks!!

I hope that this has helped you in resolving your query.

If it has answered your query then please mark the question as resolved otherwise please reply to this answer for further clarification or post a new question!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000/2003