How to format contents of text box?

[Buakaw]

I have a text box on a form which pulls it's data from a table field which stores dates.



Right now the text box displays dates like this: 1/31/2010

I would like the text box to display: Jan 2010

What do I have to do in the property sheet to get it to do this?

I tried to change control source to "Format(MonthPaid, "mmm yyyy") but that doesn't do it.

Thanks.

[Buakaw]

Can I just add on one more question. I have a text box that displays a field from a table. However the field in the table looks up another table for it's text value.

For e.g.
Table A Table B
1 Apple
2 Orange
3 Mango

I want to display the text values like "Apple", "Orange" and "Mango", and not the numbers 1, 2 and 3.

How can I do this please? Thanks.

[timmy]

Right now the text box displays dates like this: 1/31/2010

I would like the text box to display: Jan 2010

Open the form in design view, select the text box, click the Format ribbon, under "Number" there should be a drop down box, select "Medium Date". That should be what your after.

Not sure i understand your second question... could you elaborate?

[Buakaw]

Thanks Timmy, but where is this "Format" Ribbon? I can't locate it. Is it under Design or Arrange? I did see an Input Mask field under "Data" in the Properties sheet that lists "Short Date" but the format given there is 9/27/1969.

[timmy]

should be under Form Design Tools, i posted a screenshot for you .

[Buakaw]

Thanks Timmy. Is that Access 2010? I'm using 2007 and I don't see the format group on the Ribbon.

[timmy]

no, its 2007 (im 90% sure). i actually cut that a bit small, if you could see about an inche to the right you would see:
"Database11 : Database (Access 2007) - Microsoft Access (Trial)"

All im doing is opening a form in design view and that format ribbon shows, not sure why you cant see it...

[Buakaw]

Hi Timmy, unfortunately I just can't find that field. But I did find the answer to my first question. Under the properties sheet->All->Format, I entered "mmm yyyy".

[timmy]

ah, good to know you got it sorted, strange that your UI is different to mine tho. Maybe we have different versions and are oblivious to it (me? ).

As for your second question, i cant visualise or replicate how you have those tables set up, could you try explaining them in more detail?