Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Dividing Lines
- Thread starter Jwade001
- Start date
There's no way to do this with format settings of a combo or list box, but there is a way to make it happen.
In your table that lists the races, add a column called SortOrder or something like that. Go through the table and add data that will group similar items. A number is probably best, as that will make it easiest to control sort order. Then add one record for each number you've used, with "-------" in the field that holds race. Then you'll be able to sort by both columns, only displaying one of them.
But if you do this, you'll have to put in some error checking to make sure that users don't select "------" as the race of someone involved.
Jeremy
==
Jeremy Wallace
AlphaBet City Dataworks
Access Databases for Non-Profit Organizations
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
In your table that lists the races, add a column called SortOrder or something like that. Go through the table and add data that will group similar items. A number is probably best, as that will make it easiest to control sort order. Then add one record for each number you've used, with "-------" in the field that holds race. Then you'll be able to sort by both columns, only displaying one of them.
But if you do this, you'll have to put in some error checking to make sure that users don't select "------" as the race of someone involved.
Jeremy
==
Jeremy Wallace
AlphaBet City Dataworks
Access Databases for Non-Profit Organizations
Please post in the appropriate forum with a descriptive subject; code and SQL, if referenced; and expected results. See thread181-473997 for more pointers.
- Status