I have a datasheet subform on an Access form, unfortunately, it's got more than 100 fields/columns so I had to cheat a bit to make it, i.e. the "wizard" couldn't handle it (some wizard!).
I have to find & display problem data in the subform and since it's so wide I'd like to be able to programatically (in VBA) make the target column visible,
i.e. so the user doesn't have to scroll sideways looking for the right column name.
Since the user is QAing the data it all needs to be there.
I've tried a variety of .SetFocus methods on the form, and recordset, but to no avail.
Any ideas?
Thanks, DaveBo




Reply With Quote