ms-accessformatfill
Changing the color of a subform's column
I want to change the color of a single column in a Form's SubForm. Form with subForm:
The Default View is Datasheet and should stay that way. For some reason I am struggling at assigning the color. If I select the whole column in Layout view and go to Format > Shape Fill the whole Background gets filled instead of what is intended.
I also tried changing the textBox and comboBox's fill color in the Design view:
Does nothing. Hope you could help me!
Solution
Color property settings are ignored in Datasheet view.
However, Conditional Formatting can impact display color of textbox and combobox in Single/Continuous/Datasheet/Layout views.
Continuous view can be arranged to look like Datasheet, although Datasheet sort/filter features would not be available.
- Data update error with SharePoint 2010 and MS Access 2010
- Access TextBox does not update during VBA loop, only after
- How can I get my Access form to prevent editing of a field once saved?
- How to show 2nd combobox values from a table field based on the 1st combobox value on change event
- Microsoft Access SQL query
- Mod with Doubles
- SQL Error in Video Rental Database (JOIN ON THREE TABLES)
- QL query MS Access error "field could refer to more than one table"
- VBA Duplicate column value to an unbound field
- Getting a Resultset from a SQL Server Stored Proc in Access
- Why I cant start Remote Assistance (msra.exe) via vba "shell" since Win 11/Office 365 update?
- converting access mde from 32 bit to 64 bit
- How to copy a text value from a textfield with Control Source to another unbound textfield of the same form during load?
- Get length of array?
- MS Access Continuous Form: How to search a record where one field is empty?
- Automating the creation of table relations in Access using VBA
- Use Alias from one select to be used in another select
- Create an Access database file (.mdb or .accdb) using Java
- How to Select from 2 table in one OleDbDataAdaptercommand in C#
- Why does VBA code example on Microsoft's website destroy the clipboard for the rest of the computer?
- How to hide navigation pane in embedded PDF viewer control?
- How to pull a value from a table in Access VBA and show in a textbox based on a unique ID displayed in another textbox?
- Moving Files in MSOffice Access 2010
- How to format a general date to a distinct month in a combobox dropdown list in Access VBA?
- Date/Time Format VBA Access Query
- Use SQL to combine multiple Crosstab query results into individual Bins (ranges)
- Referring to a subform as recommended produces an error
- Building <select> in Access form
- Method 'columns' of object '_Global' failed error - VBA Access
- how can i extract the form information from a .mdb file?