(Apologies in advance, the standard of help in here is that good I'm gonna have to cheat ...)
... I'm working on a fairly large project, lots of coding involved, if & when I get stuck I'll be sure to drop by. OT VBA-wise, I'd welcome some views on a different aspect of it.
There's a "Contacts" table with maybe 200 records. Each record has an entry in the "Department" field, a string of between 7 - 16 characters. There are 15 departments, so I thought if I set up a unique departments list, I could replace the strings with the relevant number (1st department = "1", 2nd = "2", etc.), so when I need to pull out the info down the line I can just INDEX the list.
It works well enough so far, I just wondered if there was any way of assessing upfront if it's worth doing in terms of saved file size ; some kind of formula perhaps?
TIA,
Andy