record BOLD - Microsoft Access Forum - Computer Learning Zone


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

record BOLD

Ludwig Willems

2 years ago

hi, I have to enter thousands of records to which a description is attached, the description can consist of more than 1 record on the subform, since the 1st record must always be in BOLD, my question is, is it possible to ensure that the text of the 1st record will always appear in the BOLD, the subsequent records of the description on the subform must remain BOLD on false, please note that it must still be possible to manually set words in the sentence to BOLD on subsequent records afterwards . Hopefully it's a bit clear. will add print.

	Ludwig Willems OP @Reply 2 years ago

	Sami Shamma @Reply 2 years ago
Yes, What Identify the "First Record"?

	Kevin Yip @Reply 2 years ago
Conditional formatting may be able to do it, but you need something in the record to identify the first record.

	Ludwig Willems OP @Reply 2 years ago
That's the problem, you can access it with VBA to set it to BOLD, but the 2nd record may not be BOLD and neither should the consecutive records, and then you must be able to manually set the other records to BOLD words in a sentence.

	Ludwig Willems OP @Reply 2 years ago
I can't find any videos of that on Google either :( :( LOL

	Alex Hedley @Reply 2 years ago
Rich Text

	Ludwig Willems OP @Reply 2 years ago
Rich Text is already set up and I know that I can adjust the text there manually, but since I have to create thousands of records where the 1st record must always be in BOLD, I would like this 1st record that is created to always be automatically in BOLD would be useful and save a lot of time.

Kevin Robertson @Reply

2 years ago

In my example below I added a SortOrder field (add any field relevant to your project).
Remember to sort the records based on the SortOrder.
I used Conditional Formatting to always display the first record in Bold.
I included some code to increment the SortOrder to the next highest value when a new record is added.
You could, of course, default all records to zero and only increment for the first record of each Parent/Child relationship. Not too hard to do.

	Kevin Robertson @Reply 2 years ago

	Ludwig Willems OP @Reply 2 years ago
hola, might be the solution, will check it out, thanks :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View