Enhancing Date Control with rectangle and label controls

[Calgary2]

Hallo
I have a block of date controls on my form. To assist with data entry, I want to group those date controls within a rectangle and then overlay a label control on top of the upper boundary of the rectangle to display the date format required; i.e. dd-mm-yyyy.

I have seen this done on several occasions. But, there the etched line of the rectangle stops before the label text. When I tried the same, the line of the rectangle cuts right through the label text.

This link shows what I got and what I want:

http://i608.photobucket.com/albums/tt165/alexcalgary/ScreenShot001-rectangle.gif

How can I interrupt the line of the rectangle for the length of the label text?

 

[MazeWorX]

on the Format menu >> Bring to Front or Set Back

HTH

Remember amateurs built the ark - professionals built the Titanic

[flush]

 

[MazeWorX]

ohh sorry one other thing set the backgrgound color of the label to the forms background color and set the background to normal

Remember amateurs built the ark - professionals built the Titanic

[flush]

 

[Calgary2]

Hallo MazeWroX:

I used the Format menu and:
1. set the label to “Bring to Front”
2. set the rectangle to “Send to Back”
It still looks the same, i.e. the rectangle cuts across the label's text.

I am sorry, but I am at a loss about the 2nd part of your recommendations. I openend the Property Sheet for the label and looked for the properties where I could:

(1) set the colour of the label to the form's background
(2) set the background to normal

But, I could not see any property box that seems to do just that. Where would I go to make those adjustments?

 

[MazeWorX]

in desgin mode bring up the properties for the label
if the label is selected right click it
if its not selected double click it

HTH

Remember amateurs built the ark - professionals built the Titanic

[flush]

 

[Calgary2]

Hallo MazeWroX:
I set “Back Style” to Normal if that is what I should be doing.
I also tried the Back Colour property/ Custom color and attempted to match the forms colour – it’s hopeless.

As you can see from the link, I am half way there.

http://i608.photobucket.com/albums/tt165/alexcalgary/ScreenShot003-rectangleandlabel.gif

Obviously, matching the forms colour is the missing step. Please, give me some more details where and how I can match the label's background to the colour of the Form.

 

[dhookom]

You can find and copy the color of the section behind your label.

Duane
Hook'D on Access
MS Access MVP

 

[dhookom]

I believe the Back Color should be set to:
[tt] -2147483633[/tt]

Duane
Hook'D on Access
MS Access MVP

 

[Calgary2]

Thanks everyone for helping me.

-2147483633 is the correct colour.

I also found the colour code in the property sheet for the Detail Section. At first, I had searched for it in the property sheet for the entire Form. There is no colour property to be found there.

This is a good example where someone like me who has only limited Access knowledge cannot fill in the missing steps. The original idea that was mentioned to me was: “very simple – draw a rectangle and overlay a label”. As it turned out, there is a bit more to it. But, I think I have learned something about putting the properties of a control to use.

 

[MazeWorX]

Glad to here it !

Another satisfied Tek Tips customer

Remember amateurs built the ark - professionals built the Titanic

[flush]