<div>
Easy: in the report open event write some vba code that defines an array of strings say called months and load them with the months.<br />
<br />
dim months(12) as string<br />
months(1)=&quot;January&quot;<br />
Months(2)=&quot;February&quot;.. etc<br />
<br />
&nbsp;Then just insert months(variable) into you report title
</div>


Easy: in the report open event write some vba code that defines an array of strings say called months and load them with the months.

dim months(12) as string
months(1)="January"
Months(2)="February".. etc

 Then just insert months(variable) into you report title

<div>
Just click on properties of the combo box and change the names from 3 to 3 - March or whatever you like.
</div>


Just click on properties of the combo box and change the names from 3 to 3 - March or whatever you like.

<div>
Assuming the combobox is two columns, column1 is the number and column2 is the month name, use combo0.column(1)
</div>


Assuming the combobox is two columns, column1 is the number and column2 is the month name, use combo0.column(1)

<div>
I used a text box in the form to store the month name and referenced that in the report using your code.<br />
<br />
Thanks!
</div>


I used a text box in the form to store the month name and referenced that in the report using your code.

Thanks!

<div>
<div class="content wysiwyg-content">
Hi all.<br />
<br />
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.<br />
<br />
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?<br />
<br />
Thank you in advance!
</div>
</div>


Hi all.

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!

Combo Box in Access 2003

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.