Is there any reason not to create our own categories? Once you've found the tables in the database it doesn't seem that difficult
You can rename them but if you create more than three a bunch of assumptions in the code won't work, e.g., we won't have proper icons for them.
Thanks Joel, that's what I was finding. For instance I created a 4th category, but at some point I must have done that before and deleted it because the autonumber field value was set to 5. If I rebuilt the table so that the 4th record actually did have an idx value of 4 then no problem. It seemed that unless the index values actually are consecutive, then some of the 'assumptions' you make don't work. It was an out of bounds subscript error, by the way. And as us Access folks know, we can't rely on autonumber to be consecutive. Think I'll leave it as it is
Meanwhile I successfully changed function Sub CategoryIcon( ByVal ixCategory, sClass ) in
Fog Creek Home