Link to home
Create AccountLog in
Microsoft Access

Microsoft Access

--

Questions

--

Followers

Top Experts

Avatar of LJG
LJG

Continuous Form formatting / hiding fields
Access 2010  / Continuous Form

Is it possible
 to format fields so the format stays per record and doesn't change as the user goes from one record to the next?

As the user looks at the continuous form they see both records at the same time with different formatting for each record.


User generated image

Zero AI Policy

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


Avatar of John TsioumprisJohn Tsioumpris🇬🇷

So its not format but you want to control visibility of controls..or i am missing something?

Avatar of PatHartmanPatHartman🇺🇸

Continuous forms are always consistently formatted UNLESS you do something to prevent it.  Look at your conditional formatting properties.  Click on the control in design view and on the format tab in the ribbon, you will see an icon for Conditional Formatting.  That is most likely what is causing the difference.

Avatar of LJGLJG

ASKER

Thanks for the responses guys.

John:  Yes you are correct I want to  "control visibility of controls" & Control the verbiage of the labels

Pat:  Nothing is causing a problem now, I'm just trying to create a continuous form that will work for my customer.

Sorry I wasn't more clear.

Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.


Avatar of PatHartmanPatHartman🇺🇸

Your picture is not of a form so I don't know where you got the impression that rows are formatted differently automatically.

In a continuous form, ALL row instances are copies the exact same form so by definition the formatting is the same.  It is only with continuous formatting that you can alter that behavior.

Avatar of LJGLJG

ASKER

OK - let me try again

If I have a form with 5 fields (Field A, B, C, D, E)

If "Form Design" is ---> Single Form  - The user will see 1 record at a time
                                                                   * When on Record #1
                                                                         - I can make Visible Field C
                                                                         - I can make Not Visible  Field D & E
                                                                         - I can change the Caption of the Label on Field B to 'Qty Equipment'

                                                                   * When the user goes to Record #2  
                                                                         - I can make Not Visible Field C
                                                                         - I can make Visible  Field D & E
                                                                         - I can change the Caption of the Label on Field B to 'Qty People'

If "Form Design" is ---> Continuous Form (And for the sake of argument the user is seeing two records)
                                                                   * When on Record #1 (see above)    The visible property for Record #1 & #2 is the same as the Visible Property as record #1  
                                                                   * When on Record #2 (see above)    The visible property for Record #1 & #2 is the same as the Visible Property as record #2  

                                                                         IE - If on Record #1 --> Both record #1 & #2 show Field C / Qty Equipment / Does NOT show Field D & E

I would like it to show on a "Continuous Form" the same what it does on "Single Form" -->  
"control visibility of controls" & Control the verbiage of the labels   per VBA looking at data in a record          Not per record the user is on
 User generated image
Sorry about the confusion

Avatar of PatHartmanPatHartman🇺🇸

I answered your question.  The answer was "backwards" because the question was "backwards".  You MUST use conditional formatting to have variable formatting for controls on a continuous form.  For a single form, you can do it with VBA OR with Conditional formatting but as I already explained, in continuous view, what you are seeing is multiple instances of the SAME form.  Therefore, they are naturally ALWAYS the same format UNLESS you do something to alter that.  And that something is to use Conditional Formatting.

This was your question:
Is it possible
 to format fields so the format stays per record and doesn't change as the user goes from one record to the next?

So I told you how to PREVENT the format from changing from row to row because that's what you said you wanted.

Free T-shirt

Get a FREE t-shirt when you ask your first question.

We believe in human intelligence. Our moderation policy strictly prohibits the use of LLM content in our Q&A threads.


ASKER CERTIFIED SOLUTION
Avatar of Dale FyeDale Fye🇺🇸

Link to home
membership
Log in or create a free account to see answer.
Signing up is free and takes 30 seconds. No credit card required.
Create Account

Avatar of LJGLJG

ASKER

Dale
Thanks so much for the good information.  I really appreciate the info and especially the positive attitude.

Avatar of PatHartmanPatHartman🇺🇸

Apparently you didn't try Conditional Formatting.  By manipulating the color properties, you can hide controls.

Avatar of Dale FyeDale Fye🇺🇸

That's a great idea Pat, I forgot that you could set the foreground and background to the same color as the detail, but you would still have to enable/disable the controls as well, to prevent the users from tabbing or clicking into the "hidden" controls.

Reward 1Reward 2Reward 3Reward 4Reward 5Reward 6

EARN REWARDS FOR ASKING, ANSWERING, AND MORE.

Earn free swag for participating on the platform.


Avatar of PatHartmanPatHartman🇺🇸

It is awkward.  MS would have made it easier by simply including the visible property but they didn't ask my opinion.
Microsoft Access

Microsoft Access

--

Questions

--

Followers

Top Experts

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.