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


What other search criteria do you have - numbers, boolean, strings?

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


pdebaets,
The calender does appear, with unbound controls, I will test your code.

<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 id="code-8225983">Private Sub txtSearchString_GotFocus()
If cboSearchField.Value = &quot;CountDate&quot; Then
    txtSearchString.Format = &quot;Short Date&quot;
Else
    txtSearchString.Format = &quot;&quot;
End If
End Sub</code></pre>
</div>


pdebaets
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  of your code and that seemed to work. Thanks for the help.
 

Private Sub txtSearchString_GotFocus()
If cboSearchField.Value = "CountDate" Then
    txtSearchString.Format = "Short Date"
Else
    txtSearchString.Format = ""
End If
End Sub

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


See my last post for further instructions

<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.