Mar 16 2023 04:57 PM
In a Table, I have two long text field. I think they called note in older versions of Access. I use a form to input data into this two fields. In one of them, when I change the color of a word inside the field, it accepts, but in the other it doesn't accept.
I'm wondering why Access should act differently for same action (changing the color of a word inside a field) in two different field. This is an old database I have designed for English language learning purpose and it is quite an old one. I don't remember if I have changed other settings for two fields.
Mar 16 2023 07:02 PM
Mar 17 2023 04:47 AM
Mar 17 2023 04:56 AM
Mar 18 2023 12:20 AM
Mar 18 2023 07:13 AM
Mar 19 2023 11:18 AM
Mar 19 2023 11:21 AM
Mar 20 2023 08:04 AM
With "binding a form to a table" we mean setting the RecordSource property to a table name, a sql statement, or a query name. You then get the CRUD features for free. This is Access default behavior if for example you select a query in the Navigation Pane, then click on Form in the Create tab of the ribbon.
This is as opposed to unbound forms, where you would have to do the work of saving data yourself.
Mar 20 2023 02:18 PM