glad you got a solution <smile>
TO HIGHLIGHT THE CURRENT RECORD IN A CONTINUOUS FORM
put the following textbox control on your form (I usually put it in the
footer since there is often more unused space)
name --> RecordID_current
visible --> no
make the following textbox control in the detail section of your form:
name --> HighlightBox
left --> 0
top --> 0
width --> width of detail section
height --> height of detail section, like 0.2
enabled --> false
locked --> true
tabstop --> false
send this control to the back*
in the design view of the form, select HighlightBox
since HighlightBox is behind everything, you may need to select it using
the object drop-down (1st icon on the formatting toolbar or combo in the
Properties window at the top)
conditional formatting
condition 1 --> Expression Is
--> [RecordID] = [RecordID_current]
change fill/back color to LIGHT YELLOW or light gray
or whatever color you want for your highlight
If my detail section background is White, I like to use light yellow for
a highlight
WHERE
RecordID is the controlname of your ID field control
then, in the form OnCurrent event, assign a value to the unbound
RecordID_current
being unbound, it will have the same value on every record
'~~~~~~~~~~~~~~~~~~~~~~~~~
Private Sub Form_Current()
Me.RecordID_current = IIf([NewRecord], 0, [RecordID])
End Sub
'~~~~~~~~~~~~~~~~~~~~~~~~~
where [RecordID] is the controlname (or fieldname) corresponding to your
unique ID.
~~~
I also put a click event on the highlight box to SetFocus to another
control -- because, even though it is not enabled, it will come to the
front and cover everything up if it is clicked on!
~~~~~~~~~
If you are using a datasheet, I believe you will need to set up
conditional formatting for each control as you can't use a control that
spans the whole line as you can in a continuous form
* CUSTOMIZING YOUR FORM/REPORT DESIGN TOOLBAR:
when you are in the design view of a form or report, RIGHT-CLICK in a
gray area to the right of your menu bar or an icon bar
choose "Customize" from the shortcut menu
in the dialog box...
choose the *Commands* tab
Category --> *Form/Report Design*
slide these icons to the Form Design toolbar:
(they are located about 3 "screens" down in the Commands list)
Align Right -- must have >1 control selected to be enabled
Align Left -- "
Align Top -- "
Align Bottom -- "
Bring To Front
Send To Back
If you don't know what these icons do, while the customize window is
open, click on the DESCRIPTION command button for each one to see what
is does.
to be efficient, the Align button are a MUST for form and report design
the Bring To Front and Send To Back are nice to have too -- since
everything is "layered" and this gives you control on the order
~~~~~~~
It is also a good idea to open the property sheet
(from the menu --> View, Properties)
on the Format tab, you can set values such as width, height, left, top, ...
~~~~~~~
in order to align, you have to have more than one control selected
to select multiple controls:
1. click and drag an imaginary line (or rectangle) touching every
control you want to select and then let go of the mouse
OR
2. click (and drag if desired) in the vertical ruler to select
everything on that extended horizontal line (or rectangle)
OR
3. click (and drag if desired) in the horizontal ruler to select
everything on that extended vertical line (or rectangle)
OR
4. click the first object and then SHIFT-CLICK objects to toggle their
selection status
Warm Regards,
Crystal
remote programming and training
Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace
*
have an awesome day
*
Crystal I tried it again and it still didnt work? Fred yours worked
perfectly..... One last question. How do I get the entire row yellow as well?
Thanks!
fredg said:
Hello, I have a txt box named InputDate on my report and this box gives me a
list of dates that are within a year. I want to be able to color the date
yellow if its within the current 6 months. the formula I think would be
something like:
<= DateAdd("m",-6,Date) for the "InputDate" conditional format but it does
nothing? Im writing it wrong for conditional format?
You want to use
Between Date() and DateAdd("m",-6,Date())
Select the [InputDate] control.
Click on Format + Conditional Formatting
Set Condition1 to
Field Value is
Then set the expression drop-down to
Between
Next enter
Date()
in the next text dialog box.
Then enter
DateAdd("m",-6,Date())
in the next text box.
