473,322 Members | 1,314 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

Text to Memo Change Failed

This seems a bit odd and probably I'm overlooking something, but have
not been able to change a text field to a memo one. Of course, I made
the change in the related Table setting, however the display in the
expanded box on the form stops at 255 characters regardless.

The box gets its data from a four column list box and is used for an
expanded report description. And yes, I tried changing the list box
to "memo" as well, but to no avail. I have a basic secondary form for
inputting the report description and other information and after
changing this form from text to memo it worked. But as mentioned, the
display of the description in the box on the my report selection form
stops at 255 char.

Any suggestions anyone?

Thanks, Dalan
Nov 12 '05 #1
2 4240
ot***@safe-mail.net (Dalan) wrote in
news:50**************************@posting.google.c om:
This seems a bit odd and probably I'm overlooking something,
but have not been able to change a text field to a memo one.
Of course, I made the change in the related Table setting,
however the display in the expanded box on the form stops at
255 characters regardless.

The box gets its data from a four column list box and is used
for an expanded report description. And yes, I tried changing
the list box to "memo" as well, but to no avail.

List boxes implicitly convert memo to text.
I have a basic secondary form for inputting the report description and
other information and after changing this form from text to
memo it worked. But as mentioned, the display of the
description in the box on the my report selection form stops
at 255 char.

Any suggestions anyone?
Bind your textbox to the table. Goto the applicable record in the
afterupdate event of the listbox.

Thanks, Dalan


Nov 12 '05 #2
Bob Quintal <bq******@generation.net> wrote in message news:<76******************************@news.terane ws.com>...
ot***@safe-mail.net (Dalan) wrote in
news:50**************************@posting.google.c om:
This seems a bit odd and probably I'm overlooking something,
but have not been able to change a text field to a memo one.
Of course, I made the change in the related Table setting,
however the display in the expanded box on the form stops at
255 characters regardless.

The box gets its data from a four column list box and is used
for an expanded report description. And yes, I tried changing
the list box to "memo" as well, but to no avail.

List boxes implicitly convert memo to text.
I have a
basic secondary form for inputting the report description and
other information and after changing this form from text to
memo it worked. But as mentioned, the display of the
description in the box on the my report selection form stops
at 255 char.

Any suggestions anyone?


Bind your textbox to the table. Goto the applicable record in the
afterupdate event of the listbox.

Thanks, Dalan

Thanks Bob, however, could you share a bit more? The textbox is bound
to the table. What code does one need to insert in the AfterUpdate
event of the ListBox? Dalan
Nov 12 '05 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
by: Shyguy | last post by:
I want to create two buttons on a form. One would allow the user to Copy the contents of the current records memo field, the other would allow them to print. I set up a report based on the memo...
2
by: PMB | last post by:
Thank you in advance for any and all assistance. I'm trying to input data from strings to a memo field. I would like to know how to check first to see if there is text there currently and if so...
0
by: Thomas Zimmermann | last post by:
Hi I have an Accesss 97 database that imports data from an Oracle database. Some of the text fileds in the oreacle database have a fileds size larger than 255 characters. If I just link the...
1
by: JR | last post by:
Subject basically says it all however I'm trying to change all existing memo fields to text of 255 in length. Is there a single SQL query that can be used for all of them? Thanks. JR
1
by: alexsg | last post by:
A little while ago Ron P kindly responded to my inquiry on how to copy the first line of memo field into a text field, using a query: left(,instr(1,,vbCrLf)-1) This is great, but I would like...
2
by: ACF | last post by:
Hello, I’m trying to format only selected text in an RTF Memo field in Access 2007 I’m able to copy selected text in a Memo field to the Windows clipboard with following code: ...
2
by: Roger | last post by:
I've got two tables in sql2005 which have an 'ntext' field when I linked the first table in access97 last week using an odbc data source the access-field type was 'memo' when I link the 2nd...
1
by: barbara_dave | last post by:
Hi all, I want to change a field data type from Text to Memo.The reason is I need to type more text in that field. when I was saving the change I got error message "The width of a Unicode...
7
by: sphinney | last post by:
I have a datasheet style form with textbox (MyTextBox) that has the Text Format property set to "Rich Text". It is bound to a memo field in a table. How do I change the text or highlight color of...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.