How can I make a sequence of single records visible on continous f

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On my continous form I want to click on each (non-visible) record in
sequential order and make them visible/appear. I don't mind if they are white
text made black, or invisible/visible, just so long as I can make them appear
and remain 'visible' as I work through the list.

I tried using conditional formatting but the record dissapeared as soon as
it lost focus.

I don't mind what lengths or tricks I have to go to in order to acheive this
effect, but please somebody tell me it can be done! (and how?...)
 
I may be missing something here...

If they are not visible, what are you clicking on?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Again, not visible usually means you can't see it. This isn't the same as
not enabled.

I don't see how you'd have anything there to click on if it were not
visible.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Correct, it does mean that you can't see it, though it doesn't mean its not
there... just 'invisible'; say by using white text on a white background, but
with an outline box in black. If you can imagine a set of records as
described; and when the user clicks on the record, it reveals its content.

does this make sense?
 
I suppose one way to do this would be to add a procedure to the control's
Click event.

In that event procedure, you'd set either the text color or the background
color to generate the contrast.

For example, you could use something like:

Me!txtYourTextBox.BackgroundColor = vbRed

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff,

I have tried that prior to trying the conditional formatting. the first
example changes all records to red which has the undesirable effect of making
all the boxes visible. This is what made me experiment with conditional
formatting, but the problem with tha approach is that it 'hides' the
'revealed' text once the box loses focus, as when the user selects the next
box in the sequence.

Just to remind you, I am trying to make a continous form of records
appear/become visible in sequence as the user selects each one, ultimately
revealing a previously 'hidden' list.
 
If, instead of using the "Continuous Form" setting, you use the "Single
Form" setting, the change will only affect the single form.

To get the effect of continuous forms, make the single form as small (short)
as possible, then open a "tall" enough window for it to allow multiple
"rows" (i.e., forms) to be displayed.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Jeff,

Thanks for the tip on puesdo continous forms; I wished i knew that technique
earlier; it would have saved me creating an elaborate 2 form system. The
first form being single, and the 2nd form being continous. Each time the user
selects The single form record, it copies it to the ever growing 2nd
continous form. it works a treat, but I suspect that your 'tall form' would
have been cleaner; but on the upside, it was an interesting coding lesson to
do it the way I did.

thanks for your input.
 
Back
Top