Change Colour Of Image Border

Apr 14, 2005

...but I'v got a picture and I want to put a red box behind it so the picture looks like it has red borders, the problem is that the box always appears above the picture, I'm sure there must be a way to prioritize them or something but I can't find it!

View Replies


ADVERTISEMENT

Forms :: Change Border Color Of Textboxes When They Have Focus

May 3, 2013

no problem about setting a different border color for a single textbox (or combobox or listbox) which has focus. How about to change, with a small and fast VBA code avoiding to write code for each textbox, the border color (ora other textbox properties) for a many controls in a form?

I tried using 'For each ctrl in Form....', but I got only bad results. All my control are within differente pages in TAB control.

View 14 Replies View Related

Modules & VBA :: Change Color Of Border Button On Mouseover

Oct 23, 2014

I would like to change color of border button on mouseover event. How it to do?

View 4 Replies View Related

Change Background Colour !

Jan 24, 2007

Hi,

I'm currently using MS Access 2002.

I use forms to display client info and i would like to know if the following is possible, and if so, how ?

When a clients installation date is older than 6months old (date is in a text box) i would like the form's background to change colour for that paticular client.

eg/ if the clients installation date was 7 months ago, the form's background would change red - but only to that client.

Kinds Regards
Chris

View 4 Replies View Related

Page Colour Name Change

Apr 25, 2005

page colour name change

View 3 Replies View Related

Change Label Colour

Nov 3, 2006

Ok what I would like to do is have a switchboard with a number of command buttons on, each button opens to a form with a few fields within them.

Is it possible for the initial switchboard labels to be 'red', then as the related form is opened and populated the switchboard label turns 'amber' and once the form is complete the switchboard label is 'green'. See example piccie attached, to get a better understanding!

This is to enable multiple users to see at a glance the status of various jobs.

If anyone knows how I can go about this or suggest any alternatives, I'm open to suggestion.

Thanks in advance

http://img101.imageshack.us/img101/223/switchsamplert7.jpg

View 4 Replies View Related

Change Text Colour

Feb 8, 2006

Friends,

I would like some help with my form.

I would like the following:

If txtname is null (without data), then txtdob font is changed to colour white.

Any help?

Thanks.

View 1 Replies View Related

Change The Font Colour For The Whole Form?

Jan 17, 2006

I've been working on a database for quite a while now, and i've now given it out for testing, and i've come across a little problem. One of the users is colour blind, and the colour theme i've used throughout this database is causing him problems.

I have a function that can single him out when he logs in, question is, is there a way i can change the font colour for the whole database in one go through code??

I have around 12 forms with many controls and labels, i'm kind of hoping i don't have to name each control and label separately to change the font colour.

Please tell me that there’s some clever piece of code that can change the font colour on a form in one hit…..


Regards

Darren.

View 4 Replies View Related

Change Colour Of ALL Labels In Database

Feb 6, 2006

Hi

I have a problem where the user has certain contraints in colour.

I am trying to change all the colours of labels in the database to purple.

Is there any way to declare it once in the database and all label statements will pick up the new colour. Saves me going through every form. Also there are other users who want to use the database with black.

???:rolleyes:

View 2 Replies View Related

Change Colour Dependant On Field Value

Jun 28, 2006

Hello,

First please accept my apologies if this has been done before. In the attached database I am going to have a form which is continous what I am looking to do is change the colour of the box which is in the background to the associated colour from the quote table for example

if they choose water then it will look at the TBLQuoteType and change the box colour to the colour which has been assigned to that value.

Hope this explains it ok I will continue to try and figure it out but I thought I could also use your expert knowledge.

14030

Thanks again

View 5 Replies View Related

If NULL Then Change Background Colour

Aug 26, 2004

Im trying to change the background colour of some fields if the value is null or missing, but I'm not quite sure how to handle the coding. The fields in question are title, given name and surname, and if they are empty I want to change the background colour to highlight to users that they need to collect this information.
Any help that you can provide would be great!

View 4 Replies View Related

Automated Field Colour Change

Apr 17, 2005

Is it possible to get Access to automatically change the colour in a form field via code etc. My problem is that i would like to easily pick/see any out of date quotations for my customers, so when the quotation date is 30 days old the text changes to red. Any advice would be gratefully received.

View 1 Replies View Related

Need To Change A Box Colour If Chkbox = True

May 30, 2007

I have a report which i am trying to format, I want every other row's details to alternate colour which i have done (See below)

I also have on my report, a checkbox and a text feild (not sure if i could use a rectangle and format that instead , it doesn't do anything i just need it to change colour)

chkbox name = "chkClean"
Text box name = "txtclean"

I just want the back colour to go red if the check box is true and white if the check box is false

Please help

ANdy

Code:Option Compare DatabaseOption ExplicitPrivate m_RowCount As LongPrivate Sub Detail_Format(Cancel As Integer, FormatCount As Integer)m_RowCount = m_RowCount + 1 If m_RowCount / 2 = CLng(m_RowCount / 2) Then Me.Detail.BackColor = 15263976 'Change value to the color you desire Else Me.Detail.BackColor = 14811135 'Change value to the color you desire End IfIf Me.chkClean = True Then txtclean.BackColor = 255Else txtclean.BackColor = 16777215End IfEnd Sub

View 2 Replies View Related

Reports :: Colour Change In Bar Graph

Jan 30, 2015

I have a bar graph on a report in ms access that represents 4 different risks ie count on the y axis and risk type on the x axis (low, moderate high and extreme)

Question: How do i get the each bar to automatically represent the colour based on the risk colours below?

Low: Green
Moderate : Blue
High : Yellow
Extreme: Red

View 5 Replies View Related

Change The Colour Of A TextBox / Field Depending On It's Value?

Jun 7, 2006

Hello fellow programmers, I have a tricky one for you. We have decided to split our local City up into different zones. Giving each zone a number and assigning it a colour. I have a form with all the customers who want jobs done in different parts of the city. This form has a text box on it called: Zone - (which has a 3 digit number it it). I want the colour of the text box to change depending on the Zone number, in the continuous Form view. So all the customers living in Zone=111, will have a Red background colour (color), all living in Zone=222 will have a Green background colour. I know conditional formatting through the properties of the Form can be used, but it only allows me to select 3 different situations. I have many more than 3 colours that I want to assign. I am working on a VB module to define what colour numbers from the MS Access Colour Map will be assigned to each Zone number. How can I now apply this module to the form, so when it opens, all the customers who live in Zone=111 will have a Red coloured background, those living in Zone=222 will have a green colour background, etc?

View 9 Replies View Related

How To Change The Colour And Other Format Properties Of A Menu/ Toolbar?

Oct 9, 2007

Hi All,

If it is possible to change the format properties of a menu/toolbar could someone please point me in the direction of some guidance/ let me know how to go about it I would appreciate it.

Specifically I'm trying to change the menu bar's /database window's property to match my forms (and company branding).

I've Googled various phrases in both UK and US spellings (to be on the safe side) and searched a few forums (this one included) and cannot find much beyond creating customised menu/tool bars.

Many thanks

View 1 Replies View Related

Auto Colour Change Depending On Text Selected

May 5, 2005

:) Hello

Is it possible to change the colour of the text in a table. For example the word "URGENT" is selected from a combo box, and when viewed in the table it appears red.

Thanks inancipiation

Woozie

View 1 Replies View Related

Datasheet Change Single Row Colour Based On Attribute

Jan 16, 2007

Hi
I am running Access 97 and I was wondering if it was possible to change the colour(background or text) of a single record based on an attribute

I was hoping that my subform, viewing all of the records (datasheet) would look like this based on Task Des column
eg Condition = red, Awaiting = Blue
(Below is ment to look like an access datasheet view)

Property No | Task Des | MCU/ROL
PN1234/DA1 | Condtion | MCU
PN1235/DA2 | Condtion | ROL
PN1994/DA1 | Awaiting | MCU

Thanks heaps for your help

View 1 Replies View Related

General :: Using A Toggle Button To Change A Label Colour?

Feb 27, 2014

Is it possible to use a toggle button to change the colour of a label?

I assume the code should be something like this:

Code:
If Me.ToggleButton = 1 Then
Label.BackColor = RGB(0, 255, 0)
ElseIf Me.ToggleButton = 0 Then
Label.BackColor = RGB(255, 255, 255)
End If

But I've tried it in the "On Click" sections and it doesn't work.

View 6 Replies View Related

Change Colour Of Entry To Differentiate Between Students And Parents Results?

Oct 7, 2011

I have a large database of students and parents which charts their weight, waist circ., lifestyle etc. When I then create reports, is it possible to change the colour of the entry so that I can differentiate between students and parents results? In other words, can I have all student entries in red and all parents in black, for example? At the moment, when I try to change the colour of one of these, the entire column changes to that colour and I don't know how to amend my reports to do this. Please see attached.

View 2 Replies View Related

Forms :: Change Textbox Background Colour Pending Value Of Two Textboxes On Form?

Jul 9, 2013

I have a form with two textboxes that get their values from two different queries that counts records from table. If textbox1.value equals texbox2.value the textbox2.value back ground colour is green. If they are not equal textbox2.value goes red. Itried with using conditional formatting, but it doesn't work all the time as the form is not updating when it is opened.

View 4 Replies View Related

Auto Image Change

Sep 30, 2005

I have a form with cbo and the following code:

Private Sub cboOrderLocation_AfterUpdate()
If Me!cboOrderLocation = "Paradigm" Then
Me!txtOrderLocation = "PA"
Me!txtExpressAddress = "Paradigm Address"
Me!imgSelect = "LogoSmall.jpg"
ElseIf Me!cboOrderLocation = "Unassigned" Then
Me!txtOrderLocation = "NA"
Me!txtExpressAddress = "Not Assigned"
ElseIf Me!cboOrderLocation = "Express" Then
Me!txtOrderLocation = "EX"
Me!txtExpressAddress = "Slover Address"
Me!imgSelect = "LogoSmallParadigm.jpg"
End If
End Sub

The Me!txtOrderLocation and Me!txtExpressAddress both work great! I want to have it change the logo / image the same way. Is this possible? If so can someone tell me or show me how? I created an image on the form with the name imgSelect but when I compile it of course is giving me an error.

Thanks!

View 1 Replies View Related

User Change Image On Form

Sep 25, 2005

Wonder if you guys can help, I have searched the forums, but can't find an exact match to my query...

... i want my users to see a coloured image on their form to alert them to the status of a record in the database.

I have 3 very small bitmap images (named red, amber and green and stored directly next to my database ). I want to allow users to change which image should display on any given record by choosing either from a combo-box or radio buttons located next to the 'image space' on the same form. This image change will then save when the database is closed and remain until it is changed to another staus by a subsequent user at a later date.

Any ideas greatly appreciated (I'm currently at [I]'dimwit' level with coding)

Id

View 3 Replies View Related

Prevent Cursor From Moving On Image / Form Change

Feb 8, 2007

I've created a form. Within that form I have an image control. I am using this code to pull the corresponding plant image from a folder filled with JPGs.

It works just fine except one thing. When I change from record to record my cursor jumps to the center of the pulled JPG. I don't want my cursor to move at all when loading these images. Is this possible? Thanks.


Private Sub Form_Current()

Dim FileExistsbol As Boolean
Dim stFileName As String

stFileName = CurrentProject.Path & "- Landscaping Material Images" & _
[LandscapeCommonName] & ".jpg"
stFileName = Trim(stFileName)
FileExistsbol = Dir(stFileName) <> vbNullString

If FileExistsbol Then
[LandscapeMaterialImage].Visible = True
Me![LandscapeMaterialImage].Picture = stFileName
[LabelNoPictureAvailable].Visible = False
Else
[LandscapeMaterialImage].Visible = False
[LabelNoPictureAvailable].Visible = True
End If

End Sub

View 2 Replies View Related

Linked Image Path Change Doesn't Work?

Mar 18, 2008

Hello. I've searched and read a few threads concerning image controls on forms and haven't been able to find a solution to my problem (yet). Anyway, I have a form with two image controls (imgOK1 & imgOK2). The previous and current setting of the "Picture" property for both images is set to "C:MOMGraphicsfilename.bmp". The location of my images has changed and will change for each user which is "C:Documents and Settingsuser.nameMOMGraphicsfilename.bmp". I'm using the following code to set the .Picture property on form load:

Dim ImgPath
ImgPath = "C:Documents and Settings" & Environ("username") & "My DocumentsMOMGraphics"
Me.imgOK1.Picture = ImgPath & "imgButton-OK1_25%.bmp"
Me.imgOK2.Picture = ImgPath & "imgButton-OK2_25%.bmp"

When the form is opened, an error stating that the image located at "C:MOMGraphicsfilename.bmp" cannot be found; once for each image control. Then the form loads and .Picture properties appear to be set correctly as they are displayed fine. I've tried to clear the .Picture properties for both image controls using the properties editor but the original path returns as soon as the property loses focus. Is there a way to programatically set this property and make it stick so the errors are not displayed?

View 7 Replies View Related

How Do I Change An Image (Ole Object) In A Form When Changing Value Of A Combo Box?

Mar 14, 2007

My Db has 1 table with 4 columns named ID, First_name, Last_name and Photo.

ID is a counter and primary key.
First+last names are text fields.
Photo is an Ole object.

I display everything in a form that is controlled by a combo box. The combo box displays the first name and when I chage the first name with this box the last name changes too. I use this code together with the event "after update"

Code:Private Sub Combo_First_name_AfterUpdate()Me.txt_last_name.Value = Me.Combo_first_name.Column(2)

Everything works perfectly fine (txt_last_name changes according to the first name in the combo box), except that the photo of the person doesn't change. Nothing happens to the photo when changing value in the combo box or it just displays a message box with an error messages when I have tried to get it to work.

I want the ole object picture to change too, when changing the first name in the combo box.

I hope you can help me out here.

View 4 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved