How to make Form Datasheet cells unslectable?

[panoss]

I want to change the behavior of the cells in a datasheet form.
I want when someone clicks on them the text in the cell Not to be selected and the cursor NOT to enter in the cell.


I 'v partially achieved this setting focused the second column(field) on the onClick event of the first column(field). The second column is unused.
But that's not a good solution because the column that receives the focus, has to be visible, or doesn't get focus.
Is there some better solution?

[June7]

Don't want to allow editing in the textbox?
Maybe set textbox properties Locked Yes and TabStop No.

[panoss]

No I don't want to allow editing in the text box.
I tried what you suggested but doesn't do anything.
Also tried with enabled = no: the text box doesn't get selected BUT the record doesn't get selected too .
I want the record to be selected.

[June7]

Locked and TabStop work for me. Won't prevent user clicking into the box but they can't edit it.

Odd, setting Enabled to No did nothing.

[panoss]

Locked and TabStop work for me. Won't prevent user clicking into the box but they can't edit it.

Odd, setting Enabled to No did nothing.

The cursor enters in the text box.
You can select text.
I want neither of them.

[June7]

Well, only thing I know would be to use textbox Click or Enter event to set focus elsewhere.

[panoss]

I 've rejected this in my first post.

[NTC]

So one doesn't really refer to cells in databases.....but be that as it may; I believe your only solution is to use the Conditional Format feature and it may not be adequate. Look for it in the form design and read up a little on it. It takes a little getting used to. Typically it is more oriented toward visual changes such as coloring the background - but you can enter expressions and perhaps can manipulate SetFocus so the cursor won't stay in a field.

Datasheet, as a continuous form type, does not lend itself to field-specific VBA code - which is why I refer you to the Conditional Format feature. So just understand this as the way it is. You may want to manipulate the user experience to moving into a Single Form - whereby the ability to control individual fields really is unlimited...

[June7]

Conditional Formatting can set the control's Enabled property.

A continuous view form can be made to look like datasheet.