Access 16, set some fields in split form datasheet read-only

[akika]

hi,

I have a split form with a datasheet on bottom.

Form and datasheet contains these fields:
Name | Address | Phone | Email address | Date_Registered | Status

How can i set specific fields (date_registered & status) as read-only in the datasheet?

in the properties, only Allow Edits & Read only are available.

 

[theDBguy]

Just to clarify, are you saying you still want those fields as editable in the form area but read only in the datasheet?

 

[akika]

Just to clarify, are you saying you still want those fields as editable in the form area but read only in the datasheet?

yes the fields in the forms will be editable except some will be read only.
but it the datasheet is it possible to make status and date registered as editable as it will be easy to copy paste the same data for other records.

 

[theDBguy]

yes the fields in the forms will be editable except some will be read only.
but it the datasheet is it possible to make status and date registered as editable as it will be easy to copy paste the same data for other records.

Hmm, not sure if that's possible. I'll have to give it a try. But, you may end up using a subform instead.

 

[isladogs]

PMFJI
A split form looks like two separate items but is actually one form with a clever bit of trickery. So I think the answer is that its not possible to make fields editable in the single form section but locked in the datasheet.

However, you may well be able to do that using an EMULATED split form (ESF) - see http://www.mendipdatasystems.co.uk/emulated-split-form/4594398119. It is also available in sample databases area here at AWF

 

[arnelgp]

i disagree, you can Locked some field on design view and it will be applied to the form (both Split part).


Edit:
which statement is correct post#1 or post#3 (editable or read-only?)

 

[isladogs]

Whilst my own personal preference is also the unbound form with two synchronised subforms that Pat described, I can confirm the OPs requirement is indeed possible using the emulated split form I mentioned earlier. This has all the features of a standard split form but without its disadvantages

 

[isladogs]

Hi Pat
No worries. I knew you were referring to the built in Access split form. I had mentioned the ESF back on post #5 but as I haven’t used it in a couple of years (and then only for testing), I thought I’d check that it works