anyone know how to present the message if the textbox or input box is leave as blank? I mean if user dont put data in the textbox then the message presenting user to put more data...any ideas/suggestion please tell me..your help is fully appreciated.
thanks a lot 4 ur help hammbakka..Right I just try ur code given to me..the result is ok according to what I need.thanks again.
And if dont mind, do have any code/ideas to select the data relevant in the table. For example if user type the data incorrect with the record in table. So what I need is the msgbox presenting user to put the data that relevant with the record.If not promt the msg to them. any ideas/suggestion is appreciated.
anyone can show me how to change textbox into combobox? how to make sure it will bound according fieldname that we want it?
another question is how to set the form present with maximize size. my problem is when I open the form it will present not in maximize size (full screen) then need to double click on it/something else. So any ideas please suggest...your help is appreciated.
I have change my idea to use textbox that I think it better use in my case. So did anyone know how to create msgbox if the data entered is invalid or no in record? please help.
The following code, as it was explained in previous posts, will take of the Null situation. In terms of an "invalid" entry... invalid as compared to what? I might be missing something, but you need some basis for comparison before you can consider data invalid. If you're talking required fields, formatting, and input masks, explore the properties of bound textboxes.
If IsNull(Me.controlname) Then
MsgBox "Please enter a value for " & [controlname]
The 'invalid number entered' msgbox is compare to the data that doesn't exist in the database/record. So in my case I have one text box 'Number' in one table trans1 and that Number is refer in one table 'doc_pecah' (field name : document_number). So If the data is not same in 'doc_pecah' (field name : document_number), then msgbox presenting 'The number entered is invalid'.