By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,099 Members | 2,156 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,099 IT Pros & Developers. It's quick & easy.

trying to be a copycat--picture included

n8kindt
100+
P: 221
i'm using access 2007. i want to copy the idea of quickbooks pos that we use at our store b/c i know they used access when programming it. based on a multiple item form template (this is probably the same thing as continuous??), whenever a row is selected the row automatically expands to reveal various control buttons. here's a pic from their website (that i edited) to better explain what i'm talking about.



as you can see, the highlighted row appears to make a set of buttons visible while unselected rows have them hidden. i've tried messing with the can grow/shrink properties of the detail section and making textboxes (which is what i want to show/hide) become visible when the detail section is focused and hidden when loses focus through vba but the detail section never seems to shrink whenever the text boxes properties are set to invisible so every single row is gigantic.

right now my mind is going crazy trying to brainstorm a solution and i can't sleep! i'm out of ideas and hoping someone knowledgeable can point me in the right direction. i can post my code (if that would be helpful) tomorrow when i get back to work. thanks in advance!
Mar 13 '08 #1
Share this Question
Share on Google+
4 Replies


n8kindt
100+
P: 221
ok, as an update, i KNOW that it's a problem with the form itself. whatever size i adjust the detail section to in design mode, it stays the exact same size in form view even though there is plenty of blank space open. shouldn't the shrink property take care of this? i've made it work for reports and subreports... why won't it work for my form??
Mar 13 '08 #2

missinglinq
Expert 2.5K+
P: 3,532
CanShrink is only available in Reports, not Forms.

Linq ;0)>
Mar 13 '08 #3

jaxjagfan
Expert 100+
P: 254
BTW - QB and QB Pro were most likely done using Visual Studio using VB or C#. Both have a lot of custom controls not available in Access including dynamic resizing. Some apps and/or functionality can be reproduced in Access.
Mar 13 '08 #4

n8kindt
100+
P: 221
BTW - QB and QB Pro were most likely done using Visual Studio using VB or C#. Both have a lot of custom controls not available in Access including dynamic resizing. Some apps and/or functionality can be reproduced in Access.
do you mean "can't" be reproduced? if you really meant "can be reproduced" should i be asking this in the visual basic forum?
Mar 13 '08 #5

Post your reply

Sign in to post your reply or Sign up for a free account.