Formatting a text box

G

Guest

I have a text box that will have an integer value ranging from 1 to 12. It
represents the months of the year. I've tried using mmmm in the Format
property so "September" will be displayed instead of "9" but "9" is still
displayed.

Am I going about this in the right way? Any help is appreciated. Thanks.

David
 
A

Allen Browne

Set the ControlSource of your text box to:
=MonthName([SomeField])
without the formatting.

If you are using an older version of Access:
=DateSerial(2001, [SomeField], 1)
and retain your formatting. Any year will give the result.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word OLE to check spelling in text box 1
Link a text box based on drop down box with four options MS Word 365 0
Finding the right style field in VBA 0
Finding the proper style field and the numbered paragraph value within the style 0
Paragraph numbering in Word 1
Converting URLs in comments to Markdown-formatted links 2
Word macro that can call cells out of Excel for a find and replace 0
date format convert 3

Top