Search results

in that case, take note of the red, green, blue values and use them instead

is this what you mean? if so see the attached - a short function which is then called from your query

You might be able to do this with a vba function. Not at my computer at the moment but will take a look later

Make sure the backstyle is set to normal

in form design view look at the backcolor for a control that has the right colour. if it is a custom colour it might look something like this 1. if it does, copy the value (#66CCFF in this example) 2. if it is a description such as 'access theme 1' or similar, click on the 3 dot caret to the...

Aside from the fact you are not specifying a back color, perhaps the control back color is set to transparent

If you say so - they don’t matter, so I’ll drop off this thread because i think that is where the problem is Good luck

need to clarify what you mean - are you talking about the non red date in the new record row? Or something about the third row? Whichever it is you need to provide a copy of what your rule is and what field(s) it applies to together with an explanation of what the rule is supposed to do

Why code to do this? Assuming it is null why not use the format property of the control on the report On my phone so change to use the correct double quotes

Perhaps two queries , the first just the last % LIKE '@SearchTerm + '%' Which will use an index (assuming the field is indexed). And then a second query using LIKE '%' + @SearchTerm' On the results from the first query

You might need a field to allow for annulled marriages 😀

there is a display when property for controls So you can set to screen only (and use the can grow/shrink properties if required, they only work when printing the form) and of course you might have a control you want to show when printing, but not on the screen All depends on how your form...

Be aware that won’t always remove corruption - depends on the nature of the corruption

I’ve used the old web control to do something simple - display images from a windows folder, then using code to drag them on to the main form. However couldn’t get it to work with the new web browser control

Think the posts you are referring to were deleted by the poster, either because they were in the wrong thread or they decided to post something different. Not weird

To add to Colin’s comments- once you have created your post, report it to bring to the attention of moderators. They will then review and approve as appropriate. This is to prevent to posting of inappropriate or rubbish examples

If it is actually a query you are giving access to, you could set the type to snapshot

UK get all three, but rarely as destructive as in the US. Last destructive hurricane was earlier this year. I experienced an earthquake a few years back

you can on forms- I use it for different filters on the same table