Access 2007 and rich text 
May 28th, 2007, 06:35 PM
| | | |
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 29th, 2007, 10:25 AM
| | | | 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...
| | 
May 29th, 2007, 04:55 PM
| | | | 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 | 
May 29th, 2007, 05:05 PM
| | | | 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.. | 
May 30th, 2007, 01:45 PM
| | | | 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..
| | 
May 30th, 2007, 03:15 PM
| | | | 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..
| >
| |  | | | | /bytes/about
We are a network of experts and professionals in IT and software development that help one another with answers to tough questions and share insights.
Get the best answers to your questions from over 225,702 network members.
|