<div>
great little function,<br />
<br />
thanks there.<br />
<br />
my only problem now is that obviously if the key state changes you have to re-run that function to get the change noticed.<br />
<br />
is there any way of putting an ontimer event that will re-draw my form. i can then use this to check the status of the keys and also update the time (currently =Time() ).<br />
<br />

</div>


great little function,

thanks there.

my only problem now is that obviously if the key state changes you have to re-run that function to get the change noticed.

is there any way of putting an ontimer event that will re-draw my form. i can then use this to check the status of the keys and also update the time (currently =Time() ).



<div>
&lt;&lt;is there any way of putting an ontimer event that will re-draw my form. i can then use this to check the status of the keys and also update the time (currently =Time() ).<br />
&gt;&gt;<br />
<br />
&nbsp;Sure. &nbsp;ou can use OnTimer to do all that. &nbsp;I would not set the interval for much less then a second or two though.<br />
<br />
Jim.
</div>


<<is there any way of putting an ontimer event that will re-draw my form. i can then use this to check the status of the keys and also update the time (currently =Time() ).
>>

 Sure.  ou can use OnTimer to do all that.  I would not set the interval for much less then a second or two though.

Jim.

<div>
sorted.<br />
<br />
a second is jsut about ok (havnt tested with all functionality yet) but anything shorter and the display starts to go craszy.<br />
<br />
thanks again
</div>


sorted.

a second is jsut about ok (havnt tested with all functionality yet) but anything shorter and the display starts to go craszy.

thanks again

<div>
<div class="content wysiwyg-content">
how can i get the status of the num lock and caps lock keys from a vba function and hence include them on a form as either a label or a textbox.<br />
<br />
thanks
</div>
</div>


how can i get the status of the num lock and caps lock keys from a vba function and hence include them on a form as either a label or a textbox.

thanks

status of caps lock and num lock

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.