Topics Search

Rectangle Tool to create colored boxes

Rectangle Tool to create colored boxes
Views: 130
This is probably an easy thing but I cannot seem to make it work.

I have a form and have set a background color for it. All of my controls are set to transparent.

I went to use the rectangle tool to draw a box around a group of the controls, worked fine. But, when I tried to change the background color of the box, it put the rectangle on top of the controls instead of behind them. I could not find a feature like there would have been in Word to "send items back".
Sponsored Links:

More topics


Expand a Rectangle or Frame as a border

I have a report where I have several text boxes and Labels that I would like to place inside a rectangle or something similar so that they are enclosed together in the report with a nice border around them and will stay within this border. The rectangle needs to shrink or grow around the labels and text boxes when they grow or shrink

Use Name Of Rectangle For Search

I have a form in Access 2007 with a lot of rectangles on it. I want to display data based on which rectangle is clicked by the user. It seems to me as if the easiest way is to have the key field of the database contain the name of a rectangle (Box100, Box101, Box102..). As an example I have the rectangle name hard coded in (Box414 in this instance) but I would like to have the event get the name of the rectangle clicked and use that as the search criteria

DoCmd.OpenForm "DataEntry", , , "ID='Box414'"
Where "DataEntry" is the name of a data entry form and "ID='Box414" is what I want to replace with the name of the rectangle...

Listbox ColorCoding

Can a listbox have colored lines? Is it possible by any stretch?

I like color-coding, frankly need it, don't want to port out to excel. I've tried induvidual colored rectangles aside the text, however those require a lot of messy code (not to mention a million form controls) and when vertical scroll occurs it's a losing battle because, duh, the boxes don't move with the listbox. Is the impossible possible

Setting height of a rectangle in report when it opens

I have a report which shows percentages and I have a rectangle which changes depending on the percentage. I achieved this by using

yourpercentage.Height = ([Percentage] / 100) * (1440 * 4)
When the report loads.

So the higher the percentage, the higher the bar goes up the page. Simple right? Howevever, my rectangle doesnt go higher. It just varies the white space below, depending on the values.

I want to know know how to set the bottom of the rectangle as the bottom, and the top as the top.

Create the Illusion of Colored Tabs

Learn how to Create the Illusion of Colored Tabs. (video tutorial)

Image type form that displays cubicle of search result?

I am trying to create a map type form that will use the rectangle control to represent all the different cubes in an office building and I would like the cube that the person is searching for based on the employee look-up table to change either the rectangle color of the corresponding cubicle or to display an arrow. Are either of these things possible? If not how would I go about accomplishing something similar?

Display coloured rectangle, where colour changes based on table data

It's been a while since I was last here, but I need to scratch your brains for some advice.

Some background info:
I have a table named tblCompanies. In this table, there is a field named BeenContacted. The BeenContacted field is a checkbox on my form so would take a Yes/No value.

My Problem:
I would like to have a rectangle appear on the report alongside the company's name. I want the rectangle to be green if BeenContacted was True and red if BeenContacted was false for that specific company.

Using multiple combo boxes to populate a subform

I've created a form and am having difficulty linking my 2 combo boxes to the subform within the form.

I've been able to figure out how to link the combo boxes to each other so that in the first combo box I can select a category "bag" and then the second combo box provides me with the only 2options to go with "bag": "sandwich" or "tool".

Once I have selected "Bag" in the first combo box and "tool" in the second combo box, I then want a list of suppliers that sell tool bags to populate into the subform. I have been working for WEEKS to get the subform to populate data rather than remain empty.

Create a tool to fill a table

This is my first project with Access. Tutorials on the internet never correspond to my project.

I want to create a data base with only one table. The user will be able to add a new line with a tool (several text boxes to fill the blanks).

One the same panel, I want to display the tool, the table and some other functions (like the sum of a column, or print the table).

I think this very easy to do this (only one table). Yon can see on attachment a powerpoint draft of the panel.

Do you have any ideas or examples to begin my project? For the moment, I have already created the access table and put it into my panel.

Hiding controls

On certain forms & reports, I like to block the view several controls at once with a rectangle or a text box-it simplifies the form for the user. It also means I don't have to put in a bunch of Control.visible=true or false statements, but just one for the hider. When certain controls change values or buttons clicked, the rectangle uncovers and makes those controls available.

I am seeing, to me, a weird phenomena. On a columnar form, the top control only in the list always shows through the rectangle. Send to back, front doesn't affect it, it just shows. I found this true in a2003 with XP and a2007 with W