Highligh Row in datasheet

G

Gismo

Registered User.
Local time
Today, 04:23
Joined
Jun 12, 2017
Messages
1,298
Hi all, I think I asked this question before but I can not find the post. I have a few form which utilizes a datasheet and a single subform. I need the record that is selected in the datasheet to highlight the row to indicate which data is displayed in the single subform. who do I do this please
 
What do you mean highlight the row. Soes the datasheet and subform in same doem?
 
What do you mean highlight the row. Does the datasheet and subform in same form?
 
yes the datasheet and the single subform is in the same form. you select a record in the data sheet and relevant info is displayed in the single form below. when record is selected in datasheet, the row must be highlighted to indicate which record is in focus. At this point in time only the one field in the record is highlighted but I need it to maybe invert the colour, font to white and background to black
 
Tnx Minty, let me go through it, will let you know the outcome
 
I gen an error on Function GetLineNumber()
I have my control in place
 
you can also use Conditional Formatting on your Subform.
select all fields in your subform, on the Ribbon->Format->Conditional Formatting.
Choose New Rule. from the First Combobox, choose Expression Is.
Type on the textbox: [Forms]![yourMainFormName]![FieldInYourMainForm] = [FieldInYourSubform]

then change to background color or the text color.
done.
 
Hi all, I think I asked this question before but I can not find the post.
Click to expand...

Gismo

for future reference, this page shows a list of all the threads you have started

https://www.access-programmers.co.uk/forums/search.php?searchid=11993873

To get to this, click on:
User CP => Your Profile => Statistics => Find All Threads Started by ...

You can also get to this for other users by clicking on their user name to the left of a post
 
@arnelgp

I've tried doing exactly what you have suggested in the past and it didn't work.

I tried it again after reading your post
This highlights the first row in the datasheet / continuous form but the same row stays highlighted when you move through the records

Please could you post a simple example of a form / subform using CF to highlight the selected row in a datasheet
 
Last edited:
Hi arne

I can see how you've done that and agree that it works. Well done

However, not quite as simple as you originally described it .....
i.e. adding a dummy field and requerying using Form_Current event

Now you can really impress me if you wish... :o

Attached is the emulated split form example from sample databases
I've added your method to highlight the selected row

See if you can get it to work just using CF WITHOUT adding the dummy field

I look forward to your reply! :rolleyes:
 

Attachments

Gasman said:
arnelgp,

Any chance of a 2007 version please?
Click to expand...

Arne is offline
My last post uses his approach.
It was done in Access 2010 so it should work for you.
You'll recognise it as you've downloaded it before (with no CF)
 
Arneglp posted his solution to my challenge in another thread
https://www.access-programmers.co.uk/forums/showthread.php?t=40081

Very clever it is as well...well done to Arneglp

I added a further challenge to also highlight the section with a checkbox
However, I've solved that myself - see screenshot

attachment.php


EDIT:
I have also posted this updated version in the same sample databases thread it originally came from
Emulating the split form
 

Attachments

Last edited:
You must log in or register to reply here.

Similar threads

S
Solved Datasheet: Different back colors for columns and alternate row colors
Replies
17
Views
462
AHeyne
A
B
Edit a row on continuous form while the other rows are locked.
Replies
7
Views
633
MajP
MajP
D
Solved Open form with no focus
Replies
6
Views
245
The_Doc_Man
The_Doc_Man
C
Solved Highlight backcolor in only 1 input on a continuous form
Replies
10
Views
911
riktek
riktek
H
Solved How to make a form to enter multiple entries in table with same form
2
Replies
38
Views
1,270
hrdpgajjar
H

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom