Access 2007 and rich text

[ARC]

Just found out something interesting with Access 2007... In table design, if
you set a memo field to the new rich text option, and put that control on a
form, set the control to rich text, you can only use the text formatting
menus IF the control is on a parent form! If the control is placed on a form
that is a subform, the mini format toolbar, and the access toolbar will not
work!

However, if you place the control on a self-contained form / popup form,
then mini formatting menu will open after you highlight rich text.

Ok, Access 2007 will be some major re-design work. My existing app uses a
mainmenu, that contains a submenu, and I load all the various screens into
the submenu. I'll have to scrap that, and have each screen be a
self-contained form.

Interesting stuff...

[Allen Browne]

You're right. The mini-toolbar and the ribbon items for handling rich text
don't work for a rich text control in a subform.

You probably don't want to spell-check a rich-text field either: it can make
a right mess of your data (e.g. if it contains a carriage return.)

More info about these items:
http://allenbrowne.com/Access2007.html#Bugs

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ARC" <an**@andyc.comwrote in message
news:kg***************@newssvr21.news.prodigy.net. ..

Just found out something interesting with Access 2007... In table design,
if you set a memo field to the new rich text option, and put that control
on a form, set the control to rich text, you can only use the text
formatting menus IF the control is on a parent form! If the control is
placed on a form that is a subform, the mini format toolbar, and the
access toolbar will not work!

However, if you place the control on a self-contained form / popup form,
then mini formatting menu will open after you highlight rich text.

Ok, Access 2007 will be some major re-design work. My existing app uses a
mainmenu, that contains a submenu, and I load all the various screens into
the submenu. I'll have to scrap that, and have each screen be a
self-contained form.

Interesting stuff...

[ARC]

I just read your list, Allen, and I'm sure glad I was never in the habbit of
using <Shift><Delete>!! That could be very bad...

Andy

[ARC]

Also, I've noticed the built in date picker won't show for an unbound
control...Not sure about a datasheet control yet, but I'm betting it won't
show..

[Allen Browne]

Does it make any difference if you set the Format property of the unbound
control to Short Date? That's usually enough to give Access a clue about the
intended data type.

Also, make sure there's nothing in the Input Mask.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ARC" <an**@andyc.comwrote in message
news:42******************@newssvr14.news.prodigy.n et...

Also, I've noticed the built in date picker won't show for an unbound
control...Not sure about a datasheet control yet, but I'm betting it won't
show..

[ARC]

Thanks for that.. There was something in the input mask...
"Allen Browne" <Al*********@SeeSig.Invalidwrote in message
news:46***********************@per-qv1-newsreader-01.iinet.net.au...

Does it make any difference if you set the Format property of the unbound
control to Short Date? That's usually enough to give Access a clue about
the intended data type.

Also, make sure there's nothing in the Input Mask.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ARC" <an**@andyc.comwrote in message
news:42******************@newssvr14.news.prodigy.n et...

>Also, I've noticed the built in date picker won't show for an unbound
control...Not sure about a datasheet control yet, but I'm betting it
won't show..