Search results

Actually what I did was[lace a label next to the date field and in the On Current checked to see if the record's date value is =Date(). Seems to work ok.

I see now. I never thought of using Conditional Formatting. Thanks much

This is a form and the field is editable. I really haven't tried anything yet. I'm currently displaying "Today" using the IIF but I'm unable to edit the date if I want to: [CODE]SELECT IIf([ReminderDate]=Date(),"Today",Format([ReminderDate], "ddd mmm dd")) AS Expr1, * FROM tblReminders WHERE...

I'd like to get a date field to display "Today" if the value of the field is =Date() (today). Any ideas? James

Yup, that was it! Don't get old. Thanks much, James

I'm trying use a combo box based a lookup table to filter records on a continuous form. I also in the combo box have the "All" choice to show all. I'm using this same procedure to filter records in several other of my forms. In fact I copies and pasted the Row Source to the ne combo box and...

Ah. I see. I'll utilize it. Thanks much, James

I pasted the Iff statement to the Detail's On Paint. I kept getting the object doesn't support the property or method. Every time I closed the error it popped up again. I had to close Access from the Task Manager. BTY, I misspelled again and the new bound textbox conditional formatting does...

I added a text box to the table and placed it on the form. I created 2 rules using conditional formatting one for 1 (calendar event) and one for 2 (task). That doesn't work either. Very confusing.

ReminderTypeID is a number field.

Didn't help. And, what are text delimiters?

Not for the current record. For all records in the continuous form.

I fixed the spelling but the same thing: If [ReminderTypeID] = 1 Then Me!lblReminderTypeIndicator.BackColor = vbRed Else Me!lblReminderTypeIndicator.BackColor = vbGreen End If I placed the ReminderTypeID on the form and it shows 1 for Calendar Event and 2 for Task.

I put the following in the On Load of the form but the color stays green: If [ReminderTypeID] = 1 Then Me!lblReminerTypeIndicator.BackColor = vbRed Else Me!lblReminderTypeIndicator.BackColor = vbGreen End If The 1 is the ReminderTypeID value linked to the lookup table In the relationship.

I have a reminders table for appointments and tasks. There are 2 types of reminder: calendar event and task. In a continuous form based on reminders I want to display a control that displays 1 of 2 icons depending on whether the reminders is a calendar event or a task. I'm not quite sure how tro...

Sorry, I meant Column.

I narrowed one of the rows and it reappeared. It's a split form... I guess that's all that needs to be said.

I made some minor changes to a split form. Now, a filed magically disappeared form the datasheet. When I right click on the headers and bring up the 'Unhide fields', the field is checked. Meaning it should be showing but apparently access doesn't know it. Any ideas??? James

I have another issue. I have the Backstyle set to transparent The fore color is set to white and the pressed fore color is also set to white. O set the hover fore color set to red so there is no mistaking. After clicking the button I still don't get the hover fore color but, the pressed fore...

I thought the 'Hover Color' is the background color, and 'Hover Fore Color' were two different things. 'Hover Color' is the background and 'Hover Fore Color' is the color of the text.