Blank data records coming first

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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 ....?
 
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."
 
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.

--
There's ALWAYS more than one way to skin a cat!

Answers/posts based on Access 2000

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