Continuous forms background colour - Microsoft Access / VBA

Hans Karman

Is there any way in which I can have the background colour of one or more
records set to the colour stored in a datafield within the record?

Hans Karman, Canberra, Australia

Nov 13 '05 #1

Subscribe Reply

2327

Ed Robichaud

You can change the background colour of the detail section of a continuous
form, but not for just one record. You can, however, use conditional
formatting to change the for/back colours of some/all controls of records
that satisfy the defined conditions.
-Ed

"Hans Karman" <ha**@karman.au.com> wrote in message
news:41********@news.comindico.com.au...

Is there any way in which I can have the background colour of one or more
records set to the colour stored in a datafield within the record?

Hans Karman, Canberra, Australia

Nov 13 '05 #2

Hans Karman

At what event do you activate the conditional formatting? I tried "on
current" but that seems to impact badly on performance.

"Ed Robichaud" <ed*********@wdn.com> wrote in message
news:A2******************@monger.newsread.com...

You can change the background colour of the detail section of a continuous
form, but not for just one record. You can, however, use conditional
formatting to change the for/back colours of some/all controls of records
that satisfy the defined conditions.
-Ed

"Hans Karman" <ha**@karman.au.com> wrote in message
news:41********@news.comindico.com.au...
Is there any way in which I can have the background colour of one or more records set to the colour stored in a datafield within the record?

Hans Karman, Canberra, Australia

Nov 13 '05 #3

Ed Robichaud

If you have Access 2002/XP/2003, use the Format menu, select conditional
formatting, and follow the prompts. This will change the color/font/etc of
controls. See the Access help for conditional formatting.
-Ed

"Hans Karman" <ha**@karman.au.com> wrote in message
news:41******@news.comindico.com.au...

At what event do you activate the conditional formatting? I tried "on
current" but that seems to impact badly on performance.

"Ed Robichaud" <ed*********@wdn.com> wrote in message
news:A2******************@monger.newsread.com...
You can change the background colour of the detail section of a
continuous
form, but not for just one record. You can, however, use conditional
formatting to change the for/back colours of some/all controls of records
that satisfy the defined conditions.
-Ed

"Hans Karman" <ha**@karman.au.com> wrote in message
news:41********@news.comindico.com.au...
> Is there any way in which I can have the background colour of one or more > records set to the colour stored in a datafield within the record?
>
> Hans Karman, Canberra, Australia
>
>

Nov 13 '05 #4

Similar topics

4733

javascript to change cell background colours on a timer.

by: Peter Williams | last post by:

Hi All, I want to write some javascript for a html page which does the following. Imagine that the page contains a table with 2 columns and 3 rows, e.g.: +---+---+ | A | B | +---+---+

Javascript

4001

Singling out fields on Continuous Forms

by: Cro | last post by:

Dear Access Developers, I am developing a form with 'default view' set to "continuous forms". I am suffering with a problem I can't yet see a solution too. Each record has many fields. Two...

Microsoft Access / VBA

4120

Background colour in Continuous forms

by: Hans Karman | last post by:

Is it possible to set the background colour for each record in a continuous form to the colour stored in a datafield within that record? Hans Karman, Canberra, Australia

Microsoft Access / VBA

1339

Continuous Form Colour

by: Brad | last post by:

Hi, I have read several postings about changing the colour of text for certain textboxes on a continuous forms. I however am unable to get this to work for what I am trying to do. When I put...

Microsoft Access / VBA

4852

Requery on bound combo box causes data to disappear on continuous form

by: Bill | last post by:

Problem: Combo box data disappears from view when a requery is done See "Background" below for details on tables, forms & controls On a form, I want to use the setting of bound combo box C1...

Microsoft Access / VBA

1989

changing field background colour on continous forms

by: kaisersose1995 | last post by:

Hi, I am trying to add some visual confirmation to a continous form, to let the user know if a stored date on the form has passed. I have managed to set the background colour using a simple IF...

Microsoft Access / VBA

27517

Row numbers and alternate colors to a Continuous Form

by: Michael R | last post by:

Searching the net I've found a simple technique to add row numbers and alternate colors (for the even and the uneven row) to a continuous form. 1st step: Create a textbox, send it to background...

.NET Framework

37255

Change bg colour of different records in continuous forms

by: webgirl | last post by:

Hi there, I've been searching the net & the forums here over the last few days for help with my problem & am getting myself really confused.. hoping someone may be able to help me here. I've...

Microsoft Access / VBA

6023

Access 2007 Alternate Background Color On Continuous Forms

by: Wayne | last post by:

Has anyone found the "Alternate Background Color" property in Access 2007 forms to be buggy? As I scroll a continuous form that is using an alternate background color for every second record, the...

Microsoft Access / VBA

7048

Problem With Comparison Operator <=> in G++

by: Oralloy | last post by:

Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

C / C++

7088

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

6741

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

5342

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

4783

Access Europe - Using VBA to create a class based on a table - Wed 1 May

by: isladogs | last post by:

The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...

Microsoft Access / VBA

4485

Couldn’t get equations in html when convert word .docx file to html file in C#.

by: conductexam | last post by:

I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...

C# / C Sharp

2986

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

1300

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

563

php

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP