Month Field on Form

[The Net]

On my form their's a textbox which I would like to only
display the Month Eg: Jan, Feb Mar, etc
What would I need to make this work on the form. I have a
field on my table called Month.

Thanks very much

 

[Gerald Stanley]

You would be better off using either a comboBox or a
ListBox where the dropdown list consists of Jan, Feb, Mar etc

Hope This Helps
Gerald Stanley MCSD

 

[fredg]

On my form their's a textbox which I would like to only
display the Month Eg: Jan, Feb Mar, etc
What would I need to make this work on the form. I have a
field on my table called Month.

Thanks very much

1) If you really do have a field named "Month" I would strongly urge
you to change it to something else, perhaps txtMonth or SaleMonth.
"Month" is an access reserved word and should not be used as an Access
field name.

See the appropriate Microsoft KnowledgeBase article for your version
of Access:
109312 'Reserved Words in Microsoft Access'
209187 'Acc2000: 'Reserved Words in Microsoft Access'
286335 'ACC2002: Reserved Words in Microsoft Access'

If the field "Month" (the one I know your going to change the name of)
is a Date Datatype, then all you need do is set the Form Control's
Format property to
mmm