Results 1 to 12 of 12
  1. #1
    eantar is offline Novice
    Windows 10 Access 2019
    Join Date
    Oct 2022
    Posts
    3

    Rounded Corner Forms in Microsoft Access 64bit


    Hi all,

    New on this forum.

    I have applications that user Rounded Corner Forms. I'm using the functionality provided by Isladog (Colin Riddington), not sure if he's on this forum.

    Anyway, I need to migrate these applications to 64bit Office. But the functionality in the 32bit applications uses the gdi32 and user32 libraries.

    Does anyone know of a 64bit replacement that I can use to achieve forms with rounded corners?

    Thanks

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows 11 Office 365
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,870
    eantar,
    Colin(Isladogs) is a regular on this forum and AWF. I'm sure he'll respond.

  3. #3
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    Hi @eantar
    Not sure where you got the code you are using from but the Rounded Corners code works fine in 64-bit Access. Indeed I use 64-bit Access myself.
    See the example app at: Rounded Corners in Forms for 64-bit compatible code
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

  4. #4
    jojowhite's Avatar
    jojowhite is offline Competent Performer
    Windows 11 Access 2021
    Join Date
    Jan 2025
    Posts
    430
    Windows 11 has already a Rounded corner form, so you don't need any VBA code for it.

  5. #5
    June7's Avatar
    June7 is offline VIP
    Windows 11 Access 2021
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    jojo, how does rounded corner in Windows 11 translate to rounded corner in Access?
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  6. #6
    davegri's Avatar
    davegri is offline Excess Access
    Windows 11 Access 2021
    Join Date
    May 2012
    Location
    Denver
    Posts
    3,739
    Popup forms have rounded corners and look very nice.

    Click image for larger version. 

Name:	popup.png 
Views:	27 
Size:	28.1 KB 
ID:	53148

  7. #7
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    Quote Originally Posted by jojowhite View Post
    Windows 11 has already a Rounded corner form, so you don't need any VBA code for it.
    True. However many users including both the OP and myself haven't yet moved from Windows 10.
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

  8. #8
    CJ_London is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Mar 2015
    Posts
    11,927
    To effect a rounded border I've used a form with a disabled button (with rounded corners) sized to fit to the edges of the detail section (no header or footer - if you require them, use a subform on top of the button). You can also use the command button border properties - fill, outline and effects. Set the form border to none and set the detail back color to one you would never use and in the open or load event set this colour to transparent. As with any no border form, you'll also need to put in your own code to allow the user to move or resize the form.

  9. #9
    eantar is offline Novice
    Windows 10 Access 2019
    Join Date
    Oct 2022
    Posts
    3

    Thumbs up

    Quote Originally Posted by isladogs View Post
    Hi @eantar
    Not sure where you got the code you are using from but the Rounded Corners code works fine in 64-bit Access. Indeed I use 64-bit Access myself.
    See the example app at: Rounded Corners in Forms for 64-bit compatible code
    Thanks Colin. I wasn't sure if it would work in 64bit because the libraries use "32" in the naming. So thanks for letting me know.

  10. #10
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,652
    Post 9 was moderated, I'm posting to trigger email notifications.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  11. #11
    isladogs's Avatar
    isladogs is offline Access MVP / VIP
    Windows 10 Office 365
    Join Date
    Jan 2014
    Location
    Somerset, UK
    Posts
    6,204
    Quote Originally Posted by eantar View Post
    Thanks Colin. I wasn't sure if it would work in 64bit because the libraries use "32" in the naming. So thanks for letting me know.
    For info, all examples & code on my website should work in both bitnesses unless explicitly stated otherwise.
    Colin Riddington, Access MVP, Website, email
    The more I learn, the more I know I don't know. When I know I don't know, I keep quiet!

  12. #12
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,550
    Quote Originally Posted by isladogs View Post
    True. However many users including both the OP and myself haven't yet moved from Windows 10.
    Mine are still square if not in Acdialog?
    Attached Thumbnails Attached Thumbnails Pressure.png   Pressure rnd.png  
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 09-02-2017, 10:03 AM
  2. Replies: 5
    Last Post: 10-22-2013, 01:00 PM
  3. Replies: 9
    Last Post: 03-20-2013, 11:41 AM
  4. Replies: 5
    Last Post: 03-14-2013, 09:42 AM
  5. output of queries like to have rounded numbers
    By techexpressinc in forum Queries
    Replies: 5
    Last Post: 05-28-2009, 07:56 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums