Does anyone know how to sort the field list?

[tstoneami]

When I "Add Existing Fields" I'd like the list to be sorted alphabetically...anyone know how to do this?

Thanks!

[June7]

Never thought about it but apparently the list is presented in the order fields are listed in table design view. Otherwise, no way to control the list order.

[tstoneami]

Thanks, kind of thought that's what it was.

SUGGESTION TO PROD DEV: Use case: I am working in a large table that has been evolving over time. The table is managed by a UI, and there is no way to change the actual field order. The fields in the table are logically grouped by the field's prefix characters in the field name, but because they are not ordered, I am forced to navigate up and down the field list looking for my fields. An alpha sort would have saved me a lot of time today...Just a suggestion. Thanks!

[June7]

Not sure where your suggestion will go, if anywhere. This forum is not in any way associated with Microsoft.

[RuralGuy]

An FYI: RDBMS systems tend to keep each table narrow but long. Think thin and long rather than short and fat. There is a limit of 256 fields in any table and developers rarely get anywhere near that. You can always use a 2nd table with a 1:1 relationship but it is rarely needed.