Converting month numbers to text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello again everyone :)

Is there a way to see the TEXT Months on my Form? I have 3 seperate boxes,
day, month, and year and they are set up to auto-date. Instead of seeing 10
12 2007, I would love to see OCT 12 2007.

Can this be done??

Thanks! Steph
 
Hello again everyone :)

Is there a way to see the TEXT Months on my Form? I have 3 seperate boxes,
day, month, and year and they are set up to auto-date. Instead of seeing 10
12 2007, I would love to see OCT 12 2007.

Can this be done??

Thanks! Steph
Click to expand...

Could you explain a) what you mean by "auto date" and b) why you have
three separate textboxes instead of one textbox bound to a Date/Time
field? The latter could have its Format property set to

mmm dd yyyy

to display the date in the format you suggest.

What's the structure of your table? What fields are these textboxes
bound to (if any)?


John W. Vinson[MVP]
 
Hi John, thanks for the reply.

The database that I took over had (has) 3 seperate fields in the table for
Day, Month and Year.

They are set using the =Day(Now()) for today's date.

On my form, those 3 text boxes fill in automatically with today's date
nicely. What I was wondering is instead of having them displayed in just
numbers (ie: 10 12 2007) If I could have them displayed as say OCT 12 2007.

Thanks!
 
Hi John, thanks for the reply.

The database that I took over had (has) 3 seperate fields in the table for
Day, Month and Year.

They are set using the =Day(Now()) for today's date.

On my form, those 3 text boxes fill in automatically with today's date
nicely. What I was wondering is instead of having them displayed in just
numbers (ie: 10 12 2007) If I could have them displayed as say OCT 12 2007.

Thanks!
 
Hi John, thanks for the reply.

The database that I took over had (has) 3 seperate fields in the table for
Day, Month and Year.

They are set using the =Day(Now()) for today's date.
Click to expand...

And Month(Now()) - or better Month(Date()) - and Year(Date())
respectively?
On my form, those 3 text boxes fill in automatically with today's date
nicely. What I was wondering is instead of having them displayed in just
numbers (ie: 10 12 2007) If I could have them displayed as say OCT 12 2007.
Click to expand...

What is the DATATYPE of these fields, in the table (not in the Form)?
If it's Number, then the text string OCT won't fit: it's not a numeric
value.

If you just want to display it, you could use a Control Source

=Format(Date(), "mmm")

John W. Vinson[MVP]
 
Thats all I needed, works great, thanks!!

John Vinson said:
And Month(Now()) - or better Month(Date()) - and Year(Date())
respectively?


What is the DATATYPE of these fields, in the table (not in the Form)?
If it's Number, then the text string OCT won't fit: it's not a numeric
value.

If you just want to display it, you could use a Control Source

=Format(Date(), "mmm")

John W. Vinson[MVP]
Click to expand...
 
Back
Top