Can't Edit an UNBOUND Text Box with an IIF(xxxx......) in Control Source ?

  • Thread starter Thread starter kev100 via AccessMonster.com
  • Start date Start date
K

kev100 via AccessMonster.com

I've got a form which is viewed as a DataSheet.


One of the text boxes is unbound and get's it's value from a conditional IIf
(xxx)...statment in it's Control Source.


I can kind of understand why that box should not be editable.....but...in
this situation, it wouldl help if it could be.


The countrol source is something like: =IIF([DayField]="SATURDAY","Weekend",
[DayField])

....it works fine....but sometimes the user may need to replace whatever the
displayed value is with something else.

As created.....the entire record can be deleted....and the other text boxes
which are bound to fields can be edited...but the above one cannot.

I've looked all through options for some Editable = YES/NO setting, but
cannot find anything.

Is this possible....or does Access automatically lock the item in such
situations?

Thanks
 
kev100 said:
I've got a form which is viewed as a DataSheet.


One of the text boxes is unbound and get's it's value from a
conditional IIf (xxx)...statment in it's Control Source.


I can kind of understand why that box should not be
editable.....but...in this situation, it wouldl help if it could be.
Click to expand...

No control having an expression as its ControlSource is ever editable. Also
no query field that is based on an expression is ever editable.
 
One of the text boxes is unbound and get's it's value from a conditional IIf
(xxx)...statment in it's Control Source.


I can kind of understand why that box should not be editable.....but...in
this situation, it wouldl help if it could be.
Click to expand...

Well, those are contradictory requirements. Either the field is the
result of the expression... or it isn't. If it were editable then the
expression is meaningless.

You'll need to have a real text field in your table, bound to the
textbox; you can use the IIF() expression as its Default Value in the
form, if you want it to usually be "Weekend" or whatever, but that's
the only way you'll be able to edit it.

John W. Vinson[MVP]
 
Back
Top