date/time input mask and date ordering

[jsberry]

I want to create a date field in access but only want date and month, the only way I can see to do it is with text rather than date/time otherwise it keeps putting 2017 at the end.



I also want it to order the information into date and month but cant get it to order both.

I ma using access 2016

any help on this please.

[rpeare]

were I you instead of trying to format a field I would make two fields, one for the month, one for the year (similar to web form data entry when asking for a credit card expiration month and year). Then you can limit the user to only a valid selection of months (1 through 12) and years so they can't do something crazy like 1234132/938981234

The other option is to use a format statement

format([datefield], "mm/yyyy")

but I wouldn't recommend this unless you are just using it for display purposes on a form or report and do not intend to use it as a data entry field.