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

Access 2007 and rich text

P: n/a
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...
May 28 '07 #1
Share this Question
Share on Google+
5 Replies


P: n/a
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...
May 29 '07 #2

P: n/a
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
May 29 '07 #3

P: n/a
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..
May 29 '07 #4

P: n/a
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..
May 30 '07 #5

P: n/a
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..

May 30 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.