Blank data records coming first

B

Birdy007inc

How can I make my contacts list(in form view) display my contacts in
alphabetical order but without displaying blank records before I get to the
first "A" on my contacts list ....?
 
A

Al Campagna

Birdy,
If those records are really null, you should get rid of them.
If that's not possible... add a criteria for the query behind the form against one of
the null fields...
Is Not Null
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
M

missinglinq via AccessMonster.com

Apparently your form's set up to open on a new record but still shows old
records, it must be coded to do this. In your form's code module go to the
FormLoad sub (or maybe the FormOpen sub) and look for code similar to

DoCmd.GoToRecord , , acNewRec

and delete it.
 
K

KARL DEWEY

If you want to display them after the alpha characters the use an IIF
statement like this ---
IIF([YourField] Is Null,"ZZZZZZZZZZZZZZZZZZZZZZZ", [YourField])
 
Top