|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
October 12th, 2006, 06:22 PM
posted to microsoft.public.access.forms
|
|||
|
|||
Converting month numbers to text
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 
|
|
#2
October 12th, 2006, 07:47 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Converting month numbers to text
On Thu, 12 Oct 2006 10:22:02 -0700, Scuda
wrote: 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 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]
|
|
#3
October 12th, 2006, 09:09 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Converting month numbers to text
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! "John Vinson" wrote: On Thu, 12 Oct 2006 10:22:02 -0700, Scuda wrote: 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 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]
|
|
#4
October 12th, 2006, 09:10 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Converting month numbers to text
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! "John Vinson" wrote: On Thu, 12 Oct 2006 10:22:02 -0700, Scuda wrote: 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 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]
|
|
#5
October 12th, 2006, 10:27 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Converting month numbers to text
On Thu, 12 Oct 2006 13:10:01 -0700, Scuda
wrote: 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. 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. 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]
|
|
#6
October 12th, 2006, 11:30 PM
posted to microsoft.public.access.forms
|
|||
|
|||
|
Converting month numbers to text
Thats all I needed, works great, thanks!!
"John Vinson" wrote: On Thu, 12 Oct 2006 13:10:01 -0700, Scuda wrote: 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. 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. 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]
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
