Connecting Tech Pros Worldwide Help | Site Map

Access 2007 and rich text

ARC
Guest
 
Posts: n/a
#1: May 28 '07
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
Guest
 
Posts: n/a
#2: May 29 '07

re: Access 2007 and rich text


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" <andy@andyc.comwrote in message
news:kgE6i.2604$5j1.54@newssvr21.news.prodigy.net. ..
Quote:
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
Guest
 
Posts: n/a
#3: May 29 '07

re: Access 2007 and rich text


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

re: Access 2007 and rich text


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

re: Access 2007 and rich text


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" <andy@andyc.comwrote in message
news:42Y6i.10170$2v1.7599@newssvr14.news.prodigy.n et...
Quote:
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
Guest
 
Posts: n/a
#6: May 30 '07

re: Access 2007 and rich text


Thanks for that.. There was something in the input mask...


"Allen Browne" <AllenBrowne@SeeSig.Invalidwrote in message
news:465d6e9a$0$17973$5a62ac22@per-qv1-newsreader-01.iinet.net.au...
Quote:
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" <andy@andyc.comwrote in message
news:42Y6i.10170$2v1.7599@newssvr14.news.prodigy.n et...
Quote:
>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..
>

Closed Thread