If Form Field is not null then...
Thank you for taking the time to report an issue.
What's wrong... Please write below.
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.
I want to query using a form. If a form field is empty I want the query to return all results from the table including null fields.
If I query 'Is Null' then it does return the null fields (indicating that the fields are, in fact bona fide null fields).
If I query Like IIf(IsNull([Forms]![Form1]![Date]),Is Null,"*12") - then, when the form field is null, it doesn't return the Is Null fields. (I've checked by substituting another expression that the Iif is returning 'True
Field1 = Bldg Name (maybe null)
Field2 = Street
Field3 = Floor (maybe null)
Field4 = Room (maybe null)
Field5 = City
My problem is that in front of [Floor] should be "FL:" only if that field is not null. However, I keep getting the "FL:" in front of everything. How do I not include that when that specific field is null?
The second field doesn't't seem to be picking up this value. When I click on the down arrow, there are no selections.
Secondly, I want to be able to save the form with both of these fields being blank. However, when I try to do this, I get an error message:"You tried to assign a Null value to a variable that is not a Variant data type". How do I allow the form to save when these 2 fields are null?
Most of the form is filled automatically by a query, I only select an 'option' from a dropdown list and then enter 2 dates.
When I try to submit the form I get an error that the 'Option' field cannot be null. However the field isn't null it contains the value that I selected from the list AND the record is beingcreated in the db despite the error message indicating that it can't be.
Could this be related to the 'Option' field being unbound?
I know I have used filter by form before and the dropdown lists contain what is actually in the field. Is there anyway to get this data to appear instead of Is Null or Is not Null?
I want to have a field (field 3) auto-populate based on what is entered into two other fields (field 1 & field 2).
Field 1 is a date field (when a presentation is due). Field 2 is a yes/no checkbox (if checked, it means no presentation is necessary). Field 3 would be a calculated text field (?) because text cannot be entered into Field 1.
If field 1 is null and field 2 is checked, then I want "NA" to auto populate into field 3. However, if field 1 is null and field 2 is not checked, I want "TBD" to auto populate into field 3. If field 1 is not null, then I want field 3 to be null