=> Editable text box

[Rhonda Fischer]

Hello,

I am attempting to change the properties on a text
box to edit it's contents. I have the Allow 'Edits',
'Deletes', 'Additions' and 'Data Entry' set to yes.
The text box displays data (memo 256 char) from the
table, however the user needs to be able to amend
these details, and the text box is non editable?

Any ideas would be terrific.

Thank you kindly
Rhonda

 

[Arvin Meyer]

Hello,

I am attempting to change the properties on a text
box to edit it's contents. I have the Allow 'Edits',
'Deletes', 'Additions' and 'Data Entry' set to yes.
The text box displays data (memo 256 char) from the
table, however the user needs to be able to amend
these details, and the text box is non editable?

Set DataEntry to "No". If the form is still not editable, check the Locked
and Enabled properties of the controls, and check the underlying
recordsource to make sure it's editable.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Rhonda Fischer]

Hello Arvin,

Thank you very much I have now isolated the problem
to the table fields not being editable. How do I make
this table editable. I have tried setting properties
'Required', 'Allow zero length' and 'Unicode Compression'.
I have also tried re-linking this SQL table without
much luck. My other linked tables are editable and work.
I'm not sure what properties I need to set to make
this table editable.

Thank you very much
Rhonda

-----Original Message-----
"Rhonda Fischer" <rhonda.fischer@turners-

distribution.com> wrote in message

 

[Rhonda Fischer]

Hello Ron,

Bingo, that's it the SQL Table didn't have a Primary Key,
it does now and it works. Thank you so much, it really
had baffled me.

Very Happy, thank you

Rhonda

-----Original Message-----
If you have a Sql Server Back end test to see if any fields in this table
are editable from Access.

Access will not allow edits on a Sql table if that table does not have a
Primary Key.

If the Form is based on the results of a query make sure that the query
returns an updateable recordset.

Ron W

"Rhonda Fischer" <Rhonda.Fischer@Turners-

Distribution.com> wrote in message