ComboBox field is null (how to check?)

I've a comboBox call Me.cobProbNo, At the cobProbNo On_Change() event I want to exit sub when the combo box is empty.

so I've got this:

If Me.cobProbNo = "" Then
MsgBox "no problem exist"
Exit Sub
End If

Somehow, it does NOT get into the MsgBox statement. How do I 'capture' the fact that combobox may be null?

Sponsored Links:

Related Topics

ComboBox checking to see if value exists
So I have created this combobox that requires the user to enter a password when selecting a value in my unbound combobox. If the password is incorrect then the combobox is cleared and is reset to the value it was before the update was attemped.

Now I found code on getting this to work and it works great except for one minor flaw that I am trying to add to it. If the user goes to clear the combobox thus making the value null the Msgbox appears asking for the users password but fails each time because the null username does not exist.

I'm trying to make theproper if statement to check and see if the username selected from the combobox does not exist in the usertable then it just cancels the update statement.

(between I did not make this code I borrowed it from another forum)


How to filter form when value selected from combobox is null?
I have a combobox which has null as a valid value.I want the form to get filtered when user selects null as a value also.However no filtering happens when the value is null.I would liketo know is whether it is possible to filter if the record selected is null as the filter criteria will be empty string then?I am not posting any code as my question is just that can criteriabe null and still filter?


Select a Null value in Unbound Combobox
Using Access 2010.
I've got an unbound combobox with a default value, but I still would like users to enter a Null value. I've got the Null value in the list of drop down items, but when it is selected, the combox value does not go to null, but instead goes to the default value.
Any easy way to allow null values to be selected? I know it was possible with older versions of Access, but not any more.


Cannot get values for a Combobox..
I am trying to retrieve the unique names from a table into the combobox on a form. I have the attached code for the command button on the form.

'Invalid use of Null'.

if I use another table for a string value for the same recordset, the code works and the combobox gets populated with the unique names of the field selected.

I tried to retrieve the values for different fields from the table tblPlants, but I get the same error.
It appears that I cannot populate the combobox with any of the field values from the tblPlants. But the values are not Null - by using the code line for the MsgBox (msg), I am able to see the values in the MsgBox.
Or is it some other criteria I am missing?


Use an iif statement to deal with null values in criteria boxes
I did some research on this but never found a satisfactory answer.

Why is it that in the query builder when I enter the following into the criteria box it doesn't deal with the null in the combo

iif( isnull(forms!formname!combobox), is not null ,forms!formname!combobox)

shouldnt this return any feilds that are not null


updating field whose value is the word NULL and Not a typical 'null' value
I was given a table where in a text field, the value is NULL. (Actually spelled out like that.)
I need to convert that field to a date/time one. Which is being hindered by these values of NULL.

The problem is that when I put the word NULL in the field criteria spot, Access believes that I am referring to a value of 'null' and will not do the update.
I have done "NULL", NULL, =NULL, ="NULL", is NULL. and no success.
Please remember that the actual value is not 'null'. It is a text field that has the word NULL in the field.


cascade combobox problem.
I have two comboboxes on a subform. The first combobox is used to populate the second combobox. These are placed in the detail section of the form.I want them to work this way:when I select any value from the first combobox,I want the second combobox of the same row to get populated by relevant value.

As of now, I have tried to implement this and as I select any value from the first combobox of row 1 I see the second combobox of the same row gets populated but as I go on selecting values from the first set of comboboxes I see that the values in the second set of the comboboxes above changing or becoming null.

The 1st combobox is cboRCMTask:


Check if field is Null
I have a form called AddNewCustomer which has a field called Customer_Name, now I have a button that opens another button called Command1. The thing is, when I click on that button, I need it to check if Customer_Name is empty and if it is to give an Error, and if it is not null then check if the name exists in the main table tblCustomerInformation and if it does then giveserror and once a person clicks OK on the error it empties the field and if doesn't exist then open another form.


Use an iif statement to deal with null values in criteria boxes
Why is it that in the query builder when I enter the following into the criteria box it doesn't deal with the null in the combo

iif( isnull(forms!formname!combobox), is not null ,forms!formname!combobox)

shouldn't this return any fields that are not null?


Check multiple fields for null
I have a form with three text boxes. I would like to check for null in all the fields, and if there is a null textbox display a message box


Set value of bound combobox to NULL
Goal of my Database: Recording bank transaction (money transfers from one account to another)

Details: On the form on which I record these transaction I have two combo-boxes: 1)Account Debited and 2)Account Credited.
Both combo-boxes have the same source, which is an Active-Account-Query.

I have the following code to avoid Account Credited and Account Debited to be the same:
[CODE]

This code works fine, but the problem I have is, that when the focus returns to the combobox ctlCreditAccountNumber, the account number I've entered just before (and which is wrong) is still there.

I would like the combobox to be clear of any text, after the message box disappears.

I have tried putting the rowsource to "", I have tried = Null, and Undo but nothing works. From what I gather, the reason for that is that the combobox is a bound field. That is something I can't change though.


How to Check If Two Fields are Null?
I have two currency fields in a form: [Salary1] and [Salary2].
I would like VBA to take action only if both of them are null.

I know how to do this for one field:
If (IsNull(Me.[Salary1]) = False) Then

But what is the syntax for checking if both fields are null


How to Check If Two Fields are Null?
I have two currency fields in a form: [Salary1] and [Salary2].
I would like VBA to take action only if both of them are null.

I know how to do this for one field:
If (IsNull(Me.[Salary1]) = False) Then

But what is the syntax for checking if both fields are null?


Date Field Check against Saved Date?
I have a combobox that checks for saved dates and allows someone to choose from the drop-down if they want to go back and change values in the fields from that date. I have a date field with a date picker to choose a date that has yet to be saved.

My issue is that if a person uses the date picker and chooses an existing date (instead of the combobox), I get an error for the combobox code once they try to save.

I was thinking that a simple VBA code in the Lost Focus event of the date picker could fix this. It would say something to the effect of:

If Date Chosen = Existing Date Then
MsgBox("Use combobox for existing dates")

datepickerField.SetFocus
datepickerField.Clear
End If

Essentially, the user would be unable to choose an existing date from the date picker, and would have to use the combobox instead.

I don't know how to write out the first part "Date Chosen = Existing Date". All I could think of was "DTPicker0.Value =" or "Me.DTPicker0.Value = ", but wasn't sure how to check it against existing dates.


Passing a NULL value to a date field
I'm sure the answer to this is simple, but I can't see the wood for the trees.

I have several fields in an access query that I am passing parameters values to through VBA. I use the following statement in the criteria field of the query to check if the value passed is null

IIf([oper] Is Null,"*",[oper])

[oper] is the parameter, and if null it displays all the records ("*").

This works fine expect for a field that has a date/time data type. (data type mismatch). I have tried something like

IIf([oper] Is Null, > 01/01/00, [oper])

but this doesn't display anything.


How to support nullable integer (number) field in Access / VBA
I have run into a dilemma that integer (number) variables in VBA do not seem to support null, but as for a column type in a table, that is allowed to support null.

I recall while developing with the DB2 database, that the DB2 driver / API supported the concept of fields having null indicator variables. That is a second variable that may be checked to find out the null state of the field in question. The correct way to deal with nullable fields on DB2 was to use that second variable, do the null check BEFORE attempting to access the variable which is suppose to contain the value of said field.

Does Access / VBA have anything comparable in ADODB.Recordset objects?

As-is, Access / VBA turns the NULL that was in that field of the record into 0 upon issuing a SQL UPDATE as the Integer variable defaults to 0.


Count of "true" in a crosstab
I have a convention registration database I put together several years ago. In my check-in form I was using a Combo box to select between Yes and Null for setting my "Present" field. This was prone to errors by my registration volunteers so I changed it to a check box. That change broke all my reports. I have a crosstab sub-query that gave me a count of the number of delegates and alternates present for each district. The count depended upon having a Null value for not present. Check boxes do not allow Null, and the count picks up both the yes and the no values. I'll be darned if I can come up with a way to tweek the existing reports/queries so they give me a count of Present = True


Simple check if fields are Null not Working
I am trying to check if 3 text fields on a form a empty and then setting the date "Analyst to Null if it is and it wont work.
...
am I missing something obvious


Query criteria to return all values, including nulls
I have a combobox on a form which filters a query. When nothing is entered into the combobox, the query lists all results excluding null values. This is what I want, but I also want the null values included. I am using the code below:

Public Function fCboSearch(vCboSearch As Variant)

If IsNull(vCboSearch) Or vCboSearch = "" Then
fCboSearch = "*" <<here I need it to include null values>>
Else
fCboSearch = vCboSearch
End If


Query to show Is Not Null when a check in the box?
Have a query by form that works for an inventory search. I want to add a check box control that the user can check if they only want to see results with current inventory. Getting the check box on the form is easy enough. What do I do in the query to show Is Not Null when a check in the box?