problem with filter

  • Thread starter Thread starter Andreas Wöckl
  • Start date Start date
A

Andreas Wöckl

Hi Group!

I have a very strange problem in every Access Version i use with a custom
filter. My forms are designed in a way that the user can filter by using
many various criteria. Depending on the filter (textfield, combobox,
checkbox...) he uses - the forms gets a new record source (i also tried with
serverfilter). If the users choses a filter criteria that results in a
recordset that is not eof everything is ok. if the user takes a filter that
leads to no result the following happens:

- All data sentences are away -> that's ok!
- The control of the filter criteria (e.g: a textfield with the value
"Test") does NOT display the text anymore - the same happens in comboboxes.
It seems the text gets invisible althoug you can recognize it it still here
with marking the criteria.

I tried a lot but did not find a solution until now - anyone an idea?

best regards,

andreas wöckl
 
Hi andreas

I take if from your description that you have a continuous form, and the
user can enter the criteria into unbound controls in the Form Header
section. The Form is apparently read-only, so if there are no matches, it
goes completely blank, i.e. it does not show the new record row.

If that is the case, then, yes, Access does have problems displaying the
unbound boxes correctly. The problems are not consistent across all versions
of Access, but the problem has not been fixed for several versions now, so
it looks like Microsoft expects us learn to live with it.

Our documentation of the problem is here:
Incorrect display of data
at:
http://allenbrowne.com/bug-06.html
That's not going to solve it for you, but at least you know you are not
alone with this.
 
Hi Allen!

That's exactly what my problem is and I am happy not to be alone..:)

How do you solve this problems - did you implement any workarounds?

cu

andy
 
AFAIK, there is no reliable workaround, esp. across versions.

One approach is to set the form's AllowAdditions to Yes so it can show the
new record row. To prevent the user entering a new record, cancel the form's
BeforeInsert event, or set the Locked property of the text boxes.

Other than that you cannot prevent the problem, so you just live with it.
 
Hi Allen!

Many thanks - I think I will try the thing with the AllowAdditions or I will
have to live with it - it is always good not to be alone..:)

cu

andi
 
Back
Top