Repost: How to edit a subform?

But it's January, Roger! g, d & r

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Roger Carlson" wrote in message
...
Thank, Steve and everybody. I'm pleased and proud and just a little bit
awed to be in such august company.

"Stephen Lebans"
wrote in message ...
An MVP... congratulations Roger,... well deserved!

If you want to change the size on a datasheet view, then open the form
(not in design) change order and resize as desired and then close the
form.

Warning: If you have multiple subforms, then this has to be done ONE at
a time.

Ron

Well, of course I meant:
Au·gust (ôgst)n. Inspiring awe or admiration; majestic

Maybe I should use smaller words. (Ducking and running for cover myself)

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L



"Roger Carlson" wrote in message
...
Thank, Steve and everybody. I'm pleased and proud and just a little bit
awed to be in such august company.

--
--Roger Carlson
MS Access MVP (newly minted)
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Stephen Lebans"
wrote in message ...
An MVP... congratulations Roger,... well deserved!
:-)

--
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Roger Carlson" wrote in message
...
Is the subform in Continuous or Datasheet view?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Me" wrote in message
...
I didn't get reply to my yesterday's question -

I have added a subform to a form, but for some reason after I change
the
field size, it doesn't take effect when I run the form. I want to
enlarge
the
width of some fields and also change the size of combo box display.

Can someone please point me to doc or help me out?

Thank you,
-Me

Roger deserves accolades and even others deserve thanks from me for helping
me from time to time.

However, I still haven't been able to resolve this issue completely. I am
able to resize the column as suggested by Roger, but it doesn't align the
label to the left on subform even though I have set the property for left
alignment. Any ideas?

Thanks again to Roger and everyone!

-Me


"Roger Carlson" wrote:

Thank, Steve and everybody. I'm pleased and proud and just a little bit
awed to be in such august company.

--
--Roger Carlson
MS Access MVP (newly minted)
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Stephen Lebans"
wrote in message ...
An MVP... congratulations Roger,... well deserved!
:-)

--
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Roger Carlson" wrote in message
...
Is the subform in Continuous or Datasheet view?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Me" wrote in message
...
I didn't get reply to my yesterday's question -

I have added a subform to a form, but for some reason after I change
the
field size, it doesn't take effect when I run the form. I want to
enlarge
the
width of some fields and also change the size of combo box display.

Can someone please point me to doc or help me out?

Thank you,
-Me

You really don't have much control over the format in Datasheet View, which
is why I usually use Continuous View. You can format CV to look nearly
identical to DV by butting the controls up against each other, move them to
the top of the Detail section, then snug the Footer bar up to the bottom.
Put the labels in the Form Header section and align them where you want.

If you have trouble disconnecting the label from the control to move them to
the Header section, one trick is to select the label, then CUT it (NOT
DELETE), then click in the Header and click PASTE. Then you can put it
where ever you what. (If you already know this, apologies.)

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L




"Me" wrote in message
...
Roger deserves accolades and even others deserve thanks from me for
helping
me from time to time.

However, I still haven't been able to resolve this issue completely. I am
able to resize the column as suggested by Roger, but it doesn't align the
label to the left on subform even though I have set the property for left
alignment. Any ideas?

Thanks again to Roger and everyone!

-Me


"Roger Carlson" wrote:

Thank, Steve and everybody. I'm pleased and proud and just a little bit
awed to be in such august company.

--
--Roger Carlson
MS Access MVP (newly minted)
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Stephen Lebans"

wrote in message ...
An MVP... congratulations Roger,... well deserved!
:-)

--
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Roger Carlson" wrote in message
...
Is the subform in Continuous or Datasheet view?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Me" wrote in message
...
I didn't get reply to my yesterday's question -

I have added a subform to a form, but for some reason after I
change
the
field size, it doesn't take effect when I run the form. I want to
enlarge
the
width of some fields and also change the size of combo box display.

Can someone please point me to doc or help me out?

Thank you,
-Me

Hi Roger,

Thanks for your precise explanation. I changed it to CV and put the labels
in form header and rest of the stuff as you mentined. Keep up the good work
please!

-Me

"Roger Carlson" wrote:

You really don't have much control over the format in Datasheet View, which
is why I usually use Continuous View. You can format CV to look nearly
identical to DV by butting the controls up against each other, move them to
the top of the Detail section, then snug the Footer bar up to the bottom.
Put the labels in the Form Header section and align them where you want.

If you have trouble disconnecting the label from the control to move them to
the Header section, one trick is to select the label, then CUT it (NOT
DELETE), then click in the Header and click PASTE. Then you can put it
where ever you what. (If you already know this, apologies.)

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L




"Me" wrote in message
...
Roger deserves accolades and even others deserve thanks from me for
helping
me from time to time.

However, I still haven't been able to resolve this issue completely. I am
able to resize the column as suggested by Roger, but it doesn't align the
label to the left on subform even though I have set the property for left
alignment. Any ideas?

Thanks again to Roger and everyone!

-Me


"Roger Carlson" wrote:

Thank, Steve and everybody. I'm pleased and proud and just a little bit
awed to be in such august company.

--
--Roger Carlson
MS Access MVP (newly minted)
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Stephen Lebans"

wrote in message ...
An MVP... congratulations Roger,... well deserved!
:-)

--
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"Roger Carlson" wrote in message
...
Is the subform in Continuous or Datasheet view?

--
--Roger Carlson
MS Access MVP
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/...UBED1=ACCESS-L


"Me" wrote in message
...
I didn't get reply to my yesterday's question -

I have added a subform to a form, but for some reason after I
change
the
field size, it doesn't take effect when I run the form. I want to
enlarge
the
width of some fields and also change the size of combo box display.

Can someone please point me to doc or help me out?

Thank you,
-Me