Search results

Thank you @tvanstiphout! It worked great!

Is there a way to format a Yes/No field in a List Box? I am populating the list box from a Union Query and it is displaying the Yes/No fields as 0 & -1. Is there a way to format it to True/False or Yes/No?

That makes sense.

@isladogs I checked the other computer that had a copy of the aacde file where the font did not change. The version on that computer is: Microsoft® Access® for Microsoft 365 MSO (Version 2308 Build 16.0.16731.20182) 64-bit My computer is using Version 2309 and the fonts changed. The other...

@isladogs I am using: Microsoft® Access® for Microsoft 365 MSO (Version 2309 Build 16.0.16827.20014) 64-bit I have not tried resetting the default fonts in my default theme, but I've never changed any of the defaults. However, I am using a custom theme in this database. While I defined the...

@isladogs No, I have not done either of these two things. Thank you for reporting the issue.

For about a year now, I've had buttons on forms displaying the font Calibri (Detail). A few days ago, I opened the accdb file of my database, and on some forms, not all just some, the font on the buttons changed on its own from Calibri (Detail) to System. I've attached a screenshot. At first, I...

I apologize it took so long to reply. It's been a long two weeks, plus regular work duties and life. @Gasman I changed the location to the UNC path and it didn't change anything with the "broken" computer. It did however significantly speed things up for the other two computers. Thank you...

I have a split DB with the front end working fine on two computers but not on a third. Split DB, backend saved on a mapped network drive. Each computer has its own copy of the font end. Windows 11 - Fully Updated Office 365 - Fully Updated Wednesday everything worked fine. Yesterday one...

@moke123 I have not used option groups either. Thanks for letting me know, I will definitely I will add it to my growing list of things to learn to do and use in Access!

Yes, @Gasman I should have realized as I was writing all of those statements I was referencing non-existent records. I have only been using Access since April and am slowly learning by reading in forums and watching YouTube videos. So sometimes it takes me a bit before I have the...

I have an unbound form called WeeklyUpdates where the user can select criteria and then open a couple of other forms. I am trying to create buttons to open the unbound WeeklyUpdates form using the where condition in DoCmd.OpenForm. The unbound WeeklyUpdates form has three checkboxes, New...

@theDBguy THANK YOU!!! That didn't even cross my mind! This is perfect! I knew someone here would have a solution! You guys are the best!

I 1000% agree with you, @GPGeorge, but I'm not the one paying for the project. To be honest, I didn't even notice it until he requested the background change from white to this darker blue. It was always there, just not as noticeable. The closer I get to completing the project, the pickier he...

I get this light/white dot in the bottom left-hand corner on every button I create with the following shape & bevel combo. Shape: Rectangle: Rounded Corners Effects: Bevel: Round When I change the shape to Rounded Rectangle (Small Apex), the dot disappears. I have tried using larger borders...

@isladogs I wrote down all my Windows versions and updates info from the two computers but failed to write down the Office information. However, I do know that it was on the Beta Channel. I am not sure if it changed my version and build when I deselected the insider option. Currently: Version...

I appreciate all your replies. I should have made myself more clear in my first post. I apologize, I had been trying to solve the problem for a few hours, and in my frustration, I hastily made the post without describing my issue properly, and then stepped away right after posting. The settings...

I can not edit the Application Title or change/add a display form in any of my databases. I have created brand new databases with one table and one form and I still am not able to add an Application Title or add a Display Form. When I try to type in the Application Title section nothing happens...

I have a search as you type combo box that has one column that is not changing text color. I tried the format painter copying one combo box to try to apply the formatting, but it doesn't work. I tried using a different fore color, but that didn't work. I check table settings and query settings...