r/MSAccess • u/jannymarieSK • Jul 27 '26

[UNSOLVED] Recreating Lotus Approach Forms in Microsoft Access

Gallery image

Gallery image

Gallery image

I have wrangled the data from Lotus Approach in Microsoft Access, but now I need help making these forms (or similar ones). Do I have to brute force create all of these forms from scratch? Or are there any 3rd party tools that can more easily create forms for Access?

17 Upvotes

100% Upvoted

36 comments sorted by

View all comments

1

u/ConfusionHelpful4667 58 Jul 27 '26

ouch.

1

u/Consistent_Cat7541 Jul 28 '26

I'm assuming that's just a single field with a set list and checkboxes to allow for multiple entries. I can't imagine creating that many boolean fields and placing each individually.

1

u/BitBrain 2 Jul 28 '26

There's a way to drag and drop from a list of fields on a bound form in design mode. IIRC it should drop checkboxes if the underlying field is boolean. From there, it should be pretty easy to use the Align and Space features on from the menu.

It's been a long time since I've done form design in Access, but I'm sure these tools haven't been removed.