I have a grid which I am populating using the 6-Alias property, but I had to do some tricky stuff because the database feeding the grid did not always have data in it.
I am building the grid in this manner - it keeps the grid from showing up as a blank space on the screen:
Set the recordsource to ""
Fill the database
Set the recordsource to "database"
Set the indvidual column control sources
This works just fine. No problems. Except...
When the grid is displayed, the only record showing is the very last one. I have to scroll up to see all of the records. This is really annoying, and I'm positive my customer will not like it. How do I fix this? I have tried setting the focus and issuing a scrollbar up command, I've tried setting the active cell, but nothing has worked yet.
Ideas? Thanks in advance.
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Dale Marshall
San Antonio, Texas