Month Field on Form

  • Thread starter Thread starter The Net
  • Start date Start date
T

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
 
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
 
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
Click to expand...

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
 
Back
Top