<div>
What other search criteria do you have - numbers, boolean, strings?
</div>


<div>
pdebaets,<br />
The calender does appear, with unbound controls, I will test your code.
</div>


<div>
pdebaets <br />
I tried putting the code where you suggested in the AfterUpdate and OnCurrent events but it didn't work, so I added it to the GotFocus event of txtSearchString and added .Value to cboSearchField &nbsp;of your code and that seemed to work. Thanks for the help.<br />
&nbsp;
<pre><code class="code-1 nolinks" id="code-8225983"><span>Private Sub txtSearchString_GotFocus()</span>
<span>If cboSearchField.Value = &quot;CountDate&quot; Then</span>
<span>    txtSearchString.Format = &quot;Short Date&quot;</span>
<span>Else</span>
<span>    txtSearchString.Format = &quot;&quot;</span>
<span>End If</span>
<span>End Sub</span>
</code></pre>
</div>


<div>
See my last post for further instructions
</div>


<div>
<div class="content wysiwyg-content">
I have a search form that has 2 unbound controls a combo box (cboSearchField) and a text box (txtSearchString) the combo box is used to select the search criteria and the Text box is the search string, one of the criteria is a date (CountDate). What I want to do is programmatically change the controls format property to “Short Date” when the combo box contains CountDate, so that the calendar displays, and reset it back for non-date searches. BTW this is Access 2007. 
</div>
</div>


I have a search form that has 2 unbound controls a combo box (cboSearchField) and a text box (txtSearchString) the combo box is used to select the search criteria and the Text box is the search string, one of the criteria is a date (CountDate). What I want to do is programmatically change the controls format property to “Short Date” when the combo box contains CountDate, so that the calendar displays, and reset it back for non-date searches. BTW this is Access 2007. 

Programmatically change a controls format property

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.