M mag Registered User. Local time Today, 03:40 Joined Jul 31, 2003 Messages 19 Jul 31, 2003 #1 Hello dumb question but my list boxes have about 5,000 blank lines in them how do I clear them out . access 2000 regards P plate access user
Hello dumb question but my list boxes have about 5,000 blank lines in them how do I clear them out . access 2000 regards P plate access user
louchey Member Local time Today, 03:40 Joined Mar 24, 2003 Messages 38 Jul 31, 2003 #2 I presume the list box is looking up values from a table or query?? If so, go to the source and delete any blank records. Maybe set that field as a primary key so it wont allow blank records in future. Louchey
I presume the list box is looking up values from a table or query?? If so, go to the source and delete any blank records. Maybe set that field as a primary key so it wont allow blank records in future. Louchey
M mag Registered User. Local time Today, 03:40 Joined Jul 31, 2003 Messages 19 Jul 31, 2003 #3 cheers........... louchey
ghudson Registered User. Local time Yesterday, 22:40 Joined Jun 8, 2002 Messages 6,193 Jul 31, 2003 #4 If your list box is linked to a table... Set the "Criteria" for that field in the SQL to "Is Not Null" [no quotes] HTH
If your list box is linked to a table... Set the "Criteria" for that field in the SQL to "Is Not Null" [no quotes] HTH
