Great community. Great ideas.
Welcome to ASP/Free, a community dedicated to helping beginners and professionals alike in improving their knowledge of Microsoft's development and administration technologies. Sign up today to gain access to the combined insight of tens of thousands of members.
December 19th, 2012, 09:43 AM
Table and Null
I have a table that has a bunch of fields that are blank..
I do a Is Not Null query and I get those records in the results....
I tried to Trim the field but doesn't change anything...how can the field have value with nothing there?
So I cant grab them by a Null query nor a Is Not Null query.
December 19th, 2012, 10:07 AM
Still interested in Finding a solution as to why fields that are blank to the eye are coming up in a Is Not Null query
In the mean time I simply added an "a" to the front of every record....
Then did an update on all the records = "a" to "anone"
Then went back and trimmed every record by 1 from the front, thus removing all the "a" I put in there. All records return to normal...all records with "anone" become "none"
No more Null fields.
December 19th, 2012, 03:14 PM
Fields that are blank and Fields that are null are two completely different things. You can search for blank Fields using "" as your criteria a Field that is null will not be displayed with this criteria. A blank record could be a field in which something was there and is now deleted. This field isn't null unless specifically set to null. To search for both try IsNull and "". In VBA I like to use: IF Field & "" = "" then .... this checks against both null and blank fields.
what do you mean trying to trim a blank Field. There's nothing to trim, unless I"m missing your meaning..
Last edited by meratigoerr; December 19th, 2012 at 03:17 PM.
December 19th, 2012, 06:38 PM
Mostly agree with meratigoerr. However, deleting data from a field or bound control does result in Null. I do this all the time. I set up all my tables to not allow empty strings in any fields. AFAIK, only text/memo fields can have empty string.
December 21st, 2012, 08:20 AM
Umm.. Yeah.. my bad. June you are correct.
By zeetec1 in forum .NET Development
Last Post: June 24th, 2010, 07:05 AM
By ffleitas in forum Microsoft Access Help
Last Post: May 9th, 2009, 03:16 PM
By ehsanking in forum Microsoft Access Help
Last Post: August 17th, 2005, 06:18 AM
By DannyV in forum Microsoft Access Help
Last Post: January 21st, 2005, 11:25 AM
By Saltboy in forum ASP Development
Last Post: September 23rd, 2004, 01:49 AM