Forum Discussion
Rasoul Khoshravan
Mar 16, 2023Copper Contributor
How to change color of a word inside a long text field?
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 ins...
Tom_van_Stiphout
Steel Contributor
> Table properties is different from Form properties.
That is correct. If you FIRST set the table properties, THEN create a form bound to that table, this property and many others will be re-used. But if you do the reverse, that is not the case.
That is correct. If you FIRST set the table properties, THEN create a form bound to that table, this property and many others will be re-used. But if you do the reverse, that is not the case.
Rasoul Khoshravan
Mar 19, 2023Copper Contributor
Thanks Tom. That is good point. Is bounding a form to table a default selection or I have to select it?
- Tom_van_StiphoutMar 20, 2023Steel Contributor
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.- Rasoul KhoshravanMar 20, 2023Copper ContributorThanks for your reply which is very informative for me.
I don't know the meaning f CRUD. So I serched the internet and got the following answer:
What is CRUD? CRUD is an acronym that comes from the world of computer programming and refers to the four functions that are considered necessary to implement a persistent storage application: create, read, update and delete.
I suppose this is exactly what you are aiming.