Sabtu, 19 November 2016

Re: [MS_AccessPros] Set date type fields settings

Khalid-

So, when you press Enter, that moves you to the next control. When you have entered invalid data, you get the MsgBox, but when you click OK, the focus does not stay on txtMfgDate. Correct? I suspect that because you're doing the test in the After Update of the text box where you are trying to keep the focus, Access isn't letting you. Or perhaps it is honoring the code, but then honoring your Enter key to move out. You could try moving the code to the Before Update event of the control - but I'm not sure that Before Update will fire for an unbound control. If it does work, replace the SetFocus with Cancel = True to keep the focus on the control.

John, I am back again. I have changed Default View of Form "Item File" to Continuous Forms and put List box on the detail section under the controls which are in a row and list box is populated with all above controls under txtMfgDate in List box i am showing field MfgDate.

What if user only enters month abbrv. and leaves dash and year, then we get message "Type mismatch" and on clicking Debug and on vb editor it highlights the line ==> Me.MfgDate = CDate(Me.txtMfgDate). There should be some restriction to enter complete pattern or some sort of custom msgbox. I tried to put input mask of this control with LLL\-0000;0; if year part is missing then i get message "The value you entered isn't appropriate for the input mask 'LLL\0000;' specified for this field.

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.