Conditional formatting

[Chris]

hello Group,

I need a continious form that can be edited by the user without updating the
table.

My thoughts are;
Put unbound txtboxes onto the form and make them equal the bound controls.
Then make the boound controls invisible ( or as near to invisible as they
can be)

I am trying to do this through conditional formatting but I am unsure if
what I am trying to do can be done and if it can be done how to do it.

please advise.

 

[Guest]

Hi Chris

Sounds a very strange way to do things bit you know your database best
Don't use Condidtional Format
Open the form in design view and then click the field to open the properties
box.

Select Visible = No

 

[John Spencer]

I can't really think of a way to do that in Access.

I would have a separate work table (or tables) that could be attached to the
continuous form. I would then populate the work table with the data I
wanted to use in the continuous form. I would bind the continuous form to
the work table.

With VBA you could then choose what to do with the modified data.