Applies ToAccess for Microsoft 365 Access 2024 Access 2021 Access 2019 Access 2016

Returns a Long representing the RGB color code corresponding to the specified color number.

Syntax

QBColor ( color )

The required colorargument is a whole number in the range 0–15.

Settings

The color argument has these settings:

Number

Color

Number

Color

0

Black

8

Gray

1

Blue

9

Light Blue

2

Green

10

Light Green

3

Cyan

11

Light Cyan

4

Red

12

Light Red

5

Magenta

13

Light Magenta

6

Yellow

14

Light Yellow

7

White

15

Bright White

Remarks

The color argument represents color values used by earlier versions of Basic (such as Microsoft Visual Basic for MS-DOS and the Basic Compiler). Starting with the least-significant byte, the returned value specifies the red, green, and blue values used to set the appropriate color in the RGB system used by Visual Basic for Applications.

Example

Note: Examples that follow demonstrate the use of this function in a Visual Basic for Applications (VBA) module. For more information about working with VBA, select Developer Reference in the drop-down list next to Search and enter one or more terms in the search box.

This example uses the QBColor function to change the BackColor property of the form passed in as MyForm to the color indicated by ColorCode. QBColor accepts integer values between 0 and 15.

Sub ChangeBackColor (ColorCode As Integer, _    MyForm As Form)    MyForm.BackColor = QBColor(ColorCode)End Sub

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.