>Hi...vfp6 user.
> I am trying to give my user a list of options in a cell of a grid.
> I have a combobox that I open with a Control + down arrow in the When.
> It is completely user UNfriendly. Why, you may ask?
> 1. It opens in the bottom option.
> 2. Since the control source is a field (the one that I want to populate), this bottom option is a
.
> Is there a better way to give a list of options in a grid cell (maybe a 3rd party control??).
Why not put a ComboBox 'underneath' the Grid control, put a textbox in the grid, and on the When of the textbox, pass the reference to the cell, SetFocus() to the combobox to bring the combobox up 'over' the Grid and SetFocus() to it, using the ControlSource from the textbox object you passed to it. On the Valid of the ComboBox, drop it beneath the grid, and SetFocus() back to the Grid cell you want.
The alternative approach I use is not to edit in the Grid at all; simply create a separate edit area for the current record, and double-click in a cell takes you to the edit area for the current record in the current column. Not editing in the Grid avoids the problem entirely. Use the Grid to navigate and edit/add in a separate area of the screen. Most of the apps that people originally insisted should be entered in grids have benefitted from having a clear context of thye record, with all the data for record available without scrolling around among columns, and with a more logical record layout - in most cases, the data for a line is not generally best grouped in the context of a single record linearly horizontally left to right.
> This is not a big deal, but I would rather not pass a program to my end users with this UN-feature.
>thanks...randy
