date input mask

[Guest]

I want to input a date as mm/yyyy, I do not want to include a day. Can
someone please post the input mask that I would enter to exclude the day? I
have tried a couple of my own made up things, but it still keeps reverting to
adding the date as 01.

Thank you so much!

 

[Guest]

Are inputting a date into a text box on a form?

 

[Guest]

No, it's not a text box, it's a date box. I am trying to make a mask for it.
So I guess I need to add to the question what type of Field should I use?
Date/Time or Number?

 

[Guest]

I haven't started making the form yet, I'm still in the table stage.

 

[Guest]

Hi Kelly..

perhaps this help you.

InputBox("Report Date:", "Analisis", Format(Date - 1, "dd-mmm"))
ldiaz

 

[John Vinson]

No, it's not a text box, it's a date box. I am trying to make a mask for it.
So I guess I need to add to the question what type of Field should I use?
Date/Time or Number?

Neither.

A Date/Time value is stored internally as a count of days and
fractions of a day (times) since midnight, December 30, 1899. As such
it ALWAYS has a day component.

A Number field cannot include special characters such as /.

I'd use either two Integer fields for the month and year (don't use
Month or Year as fieldnames though, they're reserved words), or a Text
field with an input mask 00/0000.

John W. Vinson[MVP]