I am attempting to improve the visual appearance of my forms and make them easier for the user. When a new record opens all the fields have the same default background color. As each field gets the focus I used conditional formating to change that color to color2 to make it easy to know which field has focus. After the field loses focus code in the lost focus event changes the color to color to color 3. ( I got this idea from a post by GHudson.) I have 3 questions:
First, An I better off using code in got focus eventas well for the second step instead of conditional fornatting?
Second, I not sure which is the best event to put the code to return the colors to the default color for a new record. I think the AfterUpdate on the form but Im wondering if there is a better one. Should it be on a property on the new record?
Third, is there a routine I can write to go through all my forms and do this code? I'm not looking forward to writing it in a couple of hundred forms.
Please bear with me, I use Access 2003 from Sweden.
Have Microsoft done something to the fields and labels in the forms in Access 2003? The depressed/inset/valley look on lables can't be seen. I've tested with transparent line and fill, as well as with colours to see what happens. No result! I can make a rectangle with depressed look, but not a text label. Also the 1 and 2 px line looks odd when using the top-left colour (looks like black). I get a thin gray line, and at 2 px the line is a bit away from the label.
I'm not using a template for the form, just the standard settings from Access.
Anything I should look for? Is it a feature that's been changed? Is it a bug I need to update Office 2003 to fix?
I have a field on a report that I was able to make bold using conditional formatting. I want to make the other fields in the row bold as well if the value of the 1st field equals a set value.
I put conditional formatting on the Contractor field
EX: Field Value Is equal to "Estimations"
I was Bid Amount, Sq Footage, =[bid amount]/[sq footage] and =[bid amount]/[estimate] fields to also be bold if the Contractor field is equal to Estimations.
Firstly, thanks to everyone for help so far. My first access project in a proffessional environment has been successful and mostly down to the people who have helped me here. I know i didnt really do it all myself but i have learned things that will hopefully serve me well going forward!
Secondly, i apologise for the ambiguously titled thread, i'll explain what i mean.
Basically i have my form that looks like the below
What i'm trying to do, is make the questions below ("Risk in Authority" and "If Not, Risk Referred?") hidden, unless the answer to "Are All Policies Acceptable?" is No.
I have managed to make it happen, but it's far from perfect. As below:
I'd set the value for Visible to No in the properties for every object in the Questions (the pretty boxes are all named things like Box123 and Label 53, all set to hidden). Then i set the "On Click" event of the No in "Are All Policies Acceptable" (called Option168) to
This works ok, but if you click on the same option twice it reverses the action.
Is there a more effective way of doing this? maybe through Validation?
Thanks for any help once again. (I've also recommended this board to a couple of guys in the office who are already proficient with Access and SQL who can hopefully contribute to the community )
Edit: As an Addendum - this formattign should only apply to one record at a time. So if the question are visible on record 1, they could still be hidden on record 2. If that's even possible.
In my Access 2010 report, I am attempting to perform conditional formatting of one field based on the difference between two fields. In particular, one field is "Time Scheduled" and the other field is "Time In". If the "Time In" is equal to or greater than 60 minutes of "Time Scheduled", I would like to format it to be red font. If it is less, I would like to format it to be green font.how I can conditionally format to do this?
I am trying to add conditional formatting to a several fields in a report. So far i can use the contional formatting to set a field called [colour] to set that field to red and bold. But i believe I need to use an Expression for all fields, so I can make all fields that = red go red. I have used the the expression:
What I am trying to do is create conditional formatting to colour fields within a form.
The conditional formatting option built in allows me to colour based on set values i.e. Value=Design turns green. I need to somehow say if Value contains the word Design turn green. This is because in addition to the word Design there will be a variable description. I tried editing the conditional format created by the wizard to Value="*Design*" but that didn't work.
Now I'm trying to write it in VBA code but am still struggling. Here's what I tried but it doesn't like it:
If InStr([Forms]![Query2]![Activity] Like "*Design")>0 Then [Forms]![Query2]![Activity].BackColor = vbGreen End If
I have a form with 2 sub forms which have identical fields from different records. I want to use conditional formatting to indicate a mismatch between 2 of the identical fields. I have been told I should use [NewField] <> [OldField] but I don't know how to complete the syntax. If I call the first sub_form_1 and the second sub_form_2 and the field name is path_length on both, how do I compile the statement?
In my form I have a calculated field that works out the time elapsed for a job, worked out as the QTY/RUN RATE which gives me the time in hours. However I couldn't format the box as a date/time, as it is a calculation and the times may go over 24 Hours which results in the date/time giving me something like 31/12/1899 16:00 for example.
I've got around this now and I've formatted the results as HH:NN:SS using a public function in a module, but the problem is this is now stored as a text field. I've tried setting this to a number field but the formatting doesn't carry over. I've tried setting a custom format in the table as HH:NN:SS but then all I get is just a bunch of 0's, no calculation results.
So how to format this as a number field properly?
Also for any extra information:
- I know you're not supposed to store calculated results, but this is slightly different, the calculated field is a standalone text box and the bound field is a formatted text box. - The reason I have to store the calculated results is because my boss wants to eventually see a chart of the total hours of jobs each day, hence why I'm asking if this can be done as a number field.
I've just created a form and I'm trying to move and size the fields but they seem to be grouped together and whatever I do to one happens to all of them. I select one field and just that field has the orange outline but when I move it they all move.
I have a form in datasheet with the fields "Date In" and "Date out" among other.
I want to be able to Change the backcolour of the "Date In" to red, yellow, or green depending on the length of time elapsed between current date and date in. This works fine on the conditional formatting, but now I only want to apply this formatting IF the "Date Out" is empty.
I have a report which I would like to apply conditional formatting on multiple fields. I would like the conditional formatting to be based on two types of criteria
First criteria would be contracts that start with the year 2014. I used the following expression which worked - InStr(1,[ContractNr],"2014" AND [DirectorInCharge]= "Joseph Steinbok" or "Adam Godson")
To this expression I would also like to highlight fields which contracts start with 2014 AND have a particular Director assigned to it. For this I used the following expression - And [DirectorInCharge]="Name"
On their own, both expressions are working but I want to combine them. How do I do this? I've tried the following - InStr(1,[ContractNr],"2014" AND [DirectorInCharge]= "Name") but then nothing is highlighted. I also tried InStr(1,[ContractNr],"2014") AND [DirectorInCharge]= "Name" - in this instance EVERY record was highlighted.
Need to confirm whether the Default formatting option in the Conditional formatting Dialog won't work in datasheet view of a form. Please note that all conditional criteria are working fine but not the Default Formatting option - only in the Datasheet view (In Single Form view the default formatting is working fine)
Really simple one for all you folks out there, but I've just been struggling for 20minutes and thats it I've decided to to seek proffesional advice. Though its been said I need it in other areas of my life too (so my ex says but..), any way I digress.
I put a tab control on a form all I want to do is format the title of each individual Tab name, i.e. font size etc, type. Had a look at the properties but nothing there seems to register.
Hey do any of you guys know if its possible to change the colour of the tabs or set them as transparent in a form plz??? I know you can set the background as transparent, but i dnt know if you can do that to the actual tabs.
Ok, don't know what I should title this problem as, but maybe you guys can help. The data stored on my table is formatted as Currency, however, when I Queue up the data, I also multiply it by a factor (exchange rate). Which turns the data into just a regular number. When I display this data on my form, I reformat it into Currencies again. However, when I click on the field, it shows the number in its raw format. How can I fix this so that when the user click on the field, they won't see the raw number but just regular Currency format? Much thanks in advance.
I am creating a database of private equity funds. I want to have a currency field for an input entitled fund size. However, I need to be able to display whether the size of the fund is in dollars or euros. How can customize a number/currency field to allow me to input the correct currency symbol?
Hi I have a database with multiple tables all linked together in various ways. I would like a master reset button that will delete every record in every table as well as resetting the auto number(s) back down to zero again. Can this be done and if so, how? Thanks in advance.
In my report the data shows patients and which unit they are in so in the detail section it shows something like this depending on how many records there are:
CVICU CVICU CVICU MSICU MSICU NICU STICU STICU STICU
I'm now modifying that report to show totals and I want to list the names of the units going across the page not down the page which shows all the records. I moved the field into a "Unit Footer" and now the report shows only one entry for each unit like this:
CVICU MSICU NICU STICU
Within the Unit footer section I don't want the names of the units going down but across like this:
CVICU MSICU NICU STICU
I know there must be an easy answer but I've looked and work on it for so long I can't see what it would be. Any help would be GREATLY appreciated.
Hi, Please see attachment. I have created a mini database which will hopefully help me in explaining the process.
Table1: Field1 - 8 rows/8 records
Form1: Field1 text box So in this box I used conditional formatting to say- whenever the date is greater than 04/05/2006, turn red. So now I scroll to record2, need to have new conditional formatting rules to apply to this record. My understanding is that I can use the remaining 2 conditions for records 2 and 3. But what about records 4,5,6 & 7. For example in record 4 I need the date to be greater than 02/15/2006, and record 8 to be greater than 05/09/2006-and as you can see when you scroll down to record 8 it has already turned red because it is governed by the rules in record1! Hopefully this makes sense! Is there a way to get around this? Is conditional formatting the only way to achieve this? If it's not what would I do? Thanks in advance for your help!
Hey everyone, I need some help with formatting a string for use with the DoCmd.RunSQL() method. I can't figure out how the hell VB deals with escape characters for the purpse of variables inside strings. I have this line right now.
strSQL = "INSERT INTO OS (OS) VALUES(" + OS.Value + ")"
This is supposed to insert one row into the "OS" Table, in the "OS" field. In my form there is a textbox called "OS" and I'm trying to insert that value into the DB table.
Two things. 1) Yes, I know, I have a lot of things named "OS" 2) Yes, I know I don't need to use a string here, but I'm just presenting this is an abbreviated example, in my full program I do in fact need a string.
