Q: Mark Jackson writes that he is having trouble getting code that picks up values from textboxes on a form to work – a Help topic said that the focus must be on the control in order to pick up the topic. A: Some of those Help topics are very old. You don’t need to […]
How to make the current row a different color for continuous forms or datasheet type subform (and for continuous forms-type main forms). Access Archon #173 Introduction When you have a form with a continuous forms or datasheet type subform, sometimes it is a good idea to highlight the current row by making its background a […]
A handy solution to the problem of disappearing form view headers and footers. Q: Bob writes that in Access 2003, when he is working on a form in design view, and turns on form headers/footers (using the View Form Header/Footer menu command), often the header and/or footer section doesn’t show when he switches to form […]
How to set column heading text for datasheets. Q: Jane H. writes that she has started using a naming convention for form controls (Helen’s comment: definitely a good idea!), but now she is seeing the control names, with prefixes, as the column headings in datasheet subforms. Is there any way to remove the prefixes in […]
How to stop Access auto-correcting your typing when you don’t want it to. Q: Maryann S. writes: “My application uses a number of two- or three-letter codes as field values. Sometimes, when I type one in, it changes to something else (for example, HGE changes to HE). How can I stop this? It is really […]
