Field is based on an expression and cannot be edited

  • Thread starter Thread starter Tiffany
  • Start date Start date
T

Tiffany

How can have an expression in a field but also allow a
user to type over the expression? When I attempt to type
over the expression I recieve a message at the bottom of
my screen the the Field is based on an expression and
cannot be edited.
 
How can have an expression in a field but also allow a
user to type over the expression? When I attempt to type
over the expression I recieve a message at the bottom of
my screen the the Field is based on an expression and
cannot be edited.
Click to expand...

If you are trying to store the value in a field, then make sure the textbox is
bound to that field (the "Control Source") and then set the textbox's "Default
Value" to the expression. Then, when a new record is created, the result of the
expression will be the entered into the field as the default value, but will
allow the user to type in a different value.
 
Tiffany-

There's no way to update a field that's the result of an expression. Think
about it. Let's say the expression is a simple MyTable.FieldA & " " &
MyTable.FieldB. If you type in the box that is the result of this
expression, how does Access know whether you mean to update FieldA or
FieldB. So, it just doesn't allow it. What is it you're really trying to
do?

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
http://www.deanforamerica.com/site/TR?pg=personal&fr_id=1090&px=1434411
 
Back
Top