<div>
Here's an example I have used before -- you will need to modify the selection statement to fit your needs.<br />
<br />

<pre><code id="code-20-39464952-1">Private Sub cbxControl_ID_KeyPress(KeyAscii As Integer)
    Debug.Print KeyAscii
    If KeyAscii = 27 Then 'esc key
        Me.cbxControl_ID.Width = 1440
    End If
End Sub</code></pre>
</div>


Here's an example I have used before -- you will need to modify the selection statement to fit your needs.



Private Sub cbxControl_ID_KeyPress(KeyAscii As Integer)
    Debug.Print KeyAscii
    If KeyAscii = 27 Then 'esc key
        Me.cbxControl_ID.Width = 1440
    End If
End Sub

<div>
great! thanks aebea and als315!! = ))
</div>


<div>
<div class="content wysiwyg-content">
guys,<br />
<br />
i have a keydown event and only want to run if an alphanumeric character is pressed. i think this is a UDF requirement.<br />
<br />
how would yall design it? if yall could share even some air code that would be great!!<br />
<br />
i'm so so sorry i'm so super overloaded now!!<br />
<br />
i'm thinking something like convert the keycode to alpha and then test it for &gt;=A &lt;=z and also for numbers. can't think of the exact implementation but something along those lines! thanks guys!! = ))
</div>
</div>


guys,

i have a keydown event and only want to run if an alphanumeric character is pressed. i think this is a UDF requirement.

how would yall design it? if yall could share even some air code that would be great!!

i'm so so sorry i'm so super overloaded now!!

i'm thinking something like convert the keycode to alpha and then test it for >=A <=z and also for numbers. can't think of the exact implementation but something along those lines! thanks guys!! = ))

test keycode for alphanumeric character

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.