Solved Getting old :-(

[Gasman]

I was about to post a thread asking for help in identifying how I managed to make text in a report control bold, if the person had passed away.

I compacted the DB and was about to attach it to the post.

I had looked (what I thought was ) everywhere, and could not find how I did it. Nothing in CF at all?

Just as I was about to attach the DB, I suddenly thought of one last place.

Yep, in the Detail_Format event.

 

[NauticalGent]

Embrace it, Paul. Its the only way to keep your sanity...

BTW, I hit the big 6-0 last month. Guess I am official a "geezer"

 

[Gasman]

Not that sophisticated.

 

[RonPaii]

NauticalGent, the good news about turning 60 is that in only 2 years you can purchase a lifetime national park pass

 

[NauticalGent]

NauticalGent, the good news about turning 60 is that in only 2 years you can purchase a lifetime national park pass

Silver linings

 

[GPGeorge]

Old? Ha.

 

[The_Doc_Man]

Old is a state of mind. The unfortunate part is that it is very hard to pack up and move to another state. This year I turned 77. My health isn't perfect but I can still walk 3 miles a day, weather and other issues permitting. And my dear wife's dislocated shoulder is responding well enough to therapy that she can do short drives on her own now, which means I don't have to schedule my walks around being her chauffeur for thrice-weekly physical therapy visits. Things are slowly looking up.

 

[DHookom]

As per my image, my heart stopped (sudden cardiac arrest) two years ago at age 69. I can verify, getting old is better than the alternative. I now have a valid reason for lapses in memory.

I recommend a coronary calcium scan for people over 60 particularly if you experience any heart related symptoms.

Don’t bold me in a report

 

[The_Doc_Man]

Had that calcium scan done a decade ago or more. Scored 100, which is actually a BAD score. But the follow-up thallium radiological assay looking for blockages turned up 0. My LDL is SO low that my cardiologist reduced my statin dose to the minimum dosage (5 mg) and, last time, the LDL was STILL so low he switched me to every other day on the statin. Blood pressure varies a bit but last was 120-something over 70-something. I'm still losing weight slowly, down 40+ pounds from my highest body weight. Nobody's complaining about that. So I guess I'm good for at least a couple of more years.

 

[DickyP]

Embrace it, Paul. Its the only way to keep your sanity...

BTW, I hit the big 6-0 last month. Guess I am official a "geezer"

No - you're a youngster! All depends on your point of view.

 

[Isaac]

Are you taking Mounjaro, or some other GLP for weight loss?.. I'm on Mounjaro 10mg x1 weekly and have lost 50 lbs, and counting. Currently at 210, goal is 190. It works!

I did tirzepatide and lost 45 pounds over ~ 3 months. stopped tirzepatide. gained 15 of them back, but now holding steady.
And the gaining back wasn't the drug's fault, obviously, it was because I went back to bowls of ice cream (for a while).
It's pricey but it works AMAZINGLY well. It attacks the problem from 3 angles at once - desire for food, insulin processing, and stomach emptying.
I combined my tirzepatide with a lot of cans of tuna for dinner, though - that's why it worked

 

[Isaac]

If you could tell your 46 year old self some piece of advice, what would it have been?

 

[DHookom]

If you could tell your 46 year old self some piece of advice, what would it have been?

If you feel a pain in your chest (even if for just 5 seconds), don’t ignore it. The same is true for other symptoms.

 

[DickyP]

If you could tell your 46 year old self some piece of advice, what would it have been?

Don't give anyone advice, especially yourself!

There is only one sensible bit of advice ever - "You are never too old for a teddybear"

 

[The_Doc_Man]

Are you taking Mounjaro, or some other GLP for weight loss?.. I'm on Mounjaro 10mg x1 weekly and have lost 50 lbs, and counting. Currently at 210, goal is 190. It works!

I take none of the weight-loss drugs. No semaglutide, no GLP-anything, no Wegovy or Mounjaro. Weight loss by diet and exercise. Slow, because I react VERY BADLY to crash diets. But I'm working on it without extreme measures. With a slow weight loss, I can avoid the incredible binges that were a sad part of my life before I made the decision that it was time to stop the out-of-control weight gains.

I now allow myself certain treats, but not as many of them. Now I use them to avoid binges.

 

[DHookom]

Getting back on topic with the OP, if you didn't use conditional formatting based on the presence of a date in the Date of Death field, how were you able to display persons data in bold text if they're dead?

I would use code like:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Me.Last_Name.FontBold = Not IsNull(Me.DateOfDeath)   
End Sub

 

[Gasman]

I would use code like:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Me.Last_Name.FontBold = Not IsNull(Me.DateOfDeath)  
End Sub

I used something similar, but with that logic.

 

[The_Doc_Man]

In my genealogy database, sometimes I don't get a date of death even though the date of birth is over 100 years ago. Therefore, I included a flag for "presumed dead." But my DOB for "unknown" is 1/1/100 and my DOD for "unknown" is 12/31/9999.

 

[Gasman]

Would that be 01/01/1900 Doc?

 

[The_Doc_Man]

No, the earliest date that can be expressed in Access is 1/1/100 (CE). I figure if I show a date more than 2000 years ago, anyone born then is dead by now. But seriously, the problem is that date CDATE(0) is in 1899, which is within the range of dates I might see for my grandparents, great-aunts and great-uncles, and miscellaneous other persons. I don't want an accidental date in a relevant time range - so my "way too early" date is as I stated. Remember, I was talking about a genealogy project - for which I've hit dates as far back as the early 1600s. A date of 0 is useless to me except if I actually DID have an event that occurred in late December, 1899.