The horizontal scroll bar will only appear if the horizontal area taken up by your <option> elements is bigger than the avaiable space of the <select>. There is no way to force a horizontal scrollbar in this html element, it just takes as much room as it needs. You can however, force the vertical size via the following:

Instead of error trapping or hard-coding for non-updateable fields when using QODBC, let VBA automatically disable them when forms open. This way, users can view but not change the data. Part 1 explained how to use schema tables to do this. Part 2 h…

We’ve all felt that sense of false security before—locking down external access to a database or component and feeling like we’ve done all we need to do to secure company data.
But that feeling is fleeting. Attacks these days can happen in many w…