472,780 Members | 1,958 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,780 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 4211
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: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
0
linyimin
by: linyimin | last post by:
Spring Startup Analyzer generates an interactive Spring application startup report that lets you understand what contributes to the application startup time and helps to optimize it. Support for...
0
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
0
by: kcodez | last post by:
As a H5 game development enthusiast, I recently wrote a very interesting little game - Toy Claw ((http://claw.kjeek.com/))。Here I will summarize and share the development experience here, and hope it...
0
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
14
DJRhino1175
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
0
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
5
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
2
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

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.