Hi,
I have a form that is a datasheet view of all the fields in a table.
What I would like to achieve is to have the user being able to select which fields they want displayed (eg from a list displaying all the fields) and then only those fields get displayed in my datasheet form.
I thought that simply setting each field's visible property to false or true in code would do the trick but when I set a fields property to false it still gets displayed!
Does anybody have any ideas as to how I can achieve this? All I need is a datasheet type view of all data in my table with the user being able to choose what fields are displayed in my form.
Any ideas appretiated. Thanks very much.
Peter
I have a form that is a datasheet view of all the fields in a table.
What I would like to achieve is to have the user being able to select which fields they want displayed (eg from a list displaying all the fields) and then only those fields get displayed in my datasheet form.
I thought that simply setting each field's visible property to false or true in code would do the trick but when I set a fields property to false it still gets displayed!
Does anybody have any ideas as to how I can achieve this? All I need is a datasheet type view of all data in my table with the user being able to choose what fields are displayed in my form.
Any ideas appretiated. Thanks very much.
Peter
