Datasheet Form with Many Fields

[RogerCooper]

Whilst that's true for a datasheet form, if you use a continuous form, disabled controls are greyed out.
If you want you can modify a continuous form so it looks like a datasheet but you have more control over its appearance.

However like previous responders I agree that your table structure isn't appropriate. Normalising will help you manage your data effectively.

Continuous forms have a width limit.

 

[RogerCooper]

I was able to gray out uneditable data, by right-clicking the column and choosing conditional formatting. Then I just set a condition met by all cells.

 

[isladogs]

Continuous forms have a width limit.

True but so do datasheet forms and the maximum width is the same for each 22.75 inches
See https://support.office.com/en-us/article/Access-specifications-0cf3c66f-9cf2-4e32-9568-98c1025bb47c

Glad you found a solution using CF with your datasheet but it is perhaps a more complicated approach than necessary

 

[RogerCooper]

True but so do datasheet forms and the maximum width is the same for each 22.75 inches
See https://support.office.com/en-us/article/Access-specifications-0cf3c66f-9cf2-4e32-9568-98c1025bb47c

Glad you found a solution using CF with your datasheet but it is perhaps a more complicated approach than necessary

There is no limit if you are in the Datasheet view. A continuous form looks like a datasheet, but Access treats it differently. That is what confused me, a datasheet view is not the same as a datasheet form.

 

[theDBguy]

I was able to gray out uneditable data, by right-clicking the column and choosing conditional formatting. Then I just set a condition met by all cells.

Hi. Thanks for the update. Cheers!

 

[isladogs]

Hi Roger
Hmm... I tested this on a humungous table of 152 fields.
When I added all the fields to a datasheet form (or if you prefer a form in datasheet view), all fields were displayed even though it said the form width was the maximum of 55.873 cm or 22.75 inches.
I then viewed the form data in Print Preview - all fields displayed though it took 66 pages to display them!
So I'm confused but you appear to be right.

I didn't spend (waste) time trying to fit all the fields side by side in a continuous form!