Combo Box in Access 2003
Posted on 2011-04-20
I have a combo box in an Access 2003 form that lists: 1, 2, 3...12 (it represents each month of the year). When the end user selects a number, say 3 it will show the sales for March.
I want to be able to show in the Report title via a text box the month name (i.e. MARCH) instead of the number (3). How can I do this besides using IIF statements, is there a way to do this in the combo box?
Thank you in advance!