Hide/Unhide Columns in Datasheet View Forms

[Armando Ruiz]

Does anyone know how can I hide and unhide columns of a
datasheet form programatically. The form I'm trying to
hide columns from is a subform on a parent form, but I
think that doesn't matter in any case.
What I want to do is to reset its recordsource having the
following columns:
ProdId, ItemDescription, Unit, Price1, Price2, Price3
Instead of having three price columns I want to have just
one and reset it to the next field by reseting the form's
recordsource. Instead of having four forms and hiding
them and showing them when I need them. the fourth form
does show all the fields though. So i just want to work
with the fourth form, but I want to show the price's
columns when i need them.

Can anyone tell me how to accomplish this task?

Thank you all in advance.
Armando Ruiz

 

[bP]

Use the visible property e.g.
if price1 > 100 then
subform!txt1.visible = true
end if