set focus
I have a form with a txt box named txtAuditor. on the exit event, i have some validation checks. i want that if the validation fails, the focus will go back to that txt box. i currectly have if variable=false then txtauditor.value="" txtauditor.setfocus endif this did not work! Any suggestions?? -- tkaplan ------------------------------------------------------------------------ tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987 View this thread: http://www.excelforum.com/showthread...hreadid=471132 |
Sure looks like it should work. One debugging strategy is to put a
Msgbox statement inside your "if variable=false then" / end if statement. That way you can deliberately cause your validation to fail and when you get the message box you know your logic is sound. if variable=false then msgbox ("About to set focus to txt.auditor") txtauditor.value="" txtauditor.setfocus endif |
it does enter the procedure- it also resets the text box I think what is happening is that it is still letting the user exit the txtbox so it sets the focus, but then the user exited. i set cancel to true and then is worked:) -- tkaplan ------------------------------------------------------------------------ tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987 View this thread: http://www.excelforum.com/showthread...hreadid=471132 |
....Or, now that I hearken back to my Access programming days, try this:
if variable=false then me.txtauditor.value="" me.txtauditor.setfocus endif |
All times are GMT +1. The time now is 09:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com