Actually, I pretty much assumed that it was... is there a FAQ that demonstrates this? or could someone briefly give an example of how to display only specific fields in a grid?
When you place a grid on a form, the grid has a complete set of properties that allow you to define everything you are asking about. In the Layout tab of the properties sheet, find ColumnCount. Type 3 and press enter. You will see three columns. Then select each Column, and in the Data tab enter the control source. It might be a good idea to place that in the textbox inside the column as well, or whatever control you have inside the column. The grid will now display only the data columns that you have entered. Doing it this way, you can place each data element in whichever column you desire.
It might be a good idea to place that in the textbox inside the column as well, or whatever control you have inside the column.
No, a grid won't let you do that. When you set the ControlSource for the column, it carries down to the textbox, or whatever control is in the column. That should work fine.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.