Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » microsoft training access course - Changing data formats

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

microsoft training access course - Changing data formats

Resolved · Low Priority · Version Standard

Reply Tue 18 Dec 2007, 17:10Delegate Jigna said...

Jigna has attended:
Access Intermediate course

Changing data formats

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

For upcoming training course dates see: Pricing & availability

Reply Thu 3 Jan 2008, 11:58Trainer Rajeev said...

RE: Changing data formats

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

Access articles

· An Essential Guide To Using The Northwind Database In Access 2010
· User-Level Security In Access
· How Microsoft Access grows with your company
· MS Access can promote teamwork
· Use Split Form View In Access For Simultaneous Views

Access tip:

Open A Combo Box Automatically

This is helpful if users need to enter large amounts of data. There are two ways to open ComboBoxes when they get the focus by using the tab keys.

When the ComboBox gets focus:

Press Alt + Down Arrow on the keyboard

For it to happen automatically, needs a bit of coding:

1. Add a combo box and a text box control to the form
2. Set the combo box's On Got Focus property to the following event procedure:

Private Sub ComboBoxName _GotFocus()

Me!ComboBoxName.Dropdown

End Sub

3. Open your form in Form View and use the TAB key to make sure it works.

View all Access hints and tips