Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Convert Memo field to Text

Status
Not open for further replies.
Steven547

Steven547

Technical User
Sep 15, 2004
165
US
Ok...think I went brain dead here at work. How do I convert a memo field to a text field?

Thanks.
 
Sort by date Sort by votes
Do you mean alter the table? You would first have to check that the field was no longer than 255 characters. Perhaps memo is a misprint?
 
Upvote 0 Downvote
You can open the table in design view and change the field there, or use CStr() if the data meets Remou's requirement.

"Artificial Intelligence is no match for Natural Stupidity"
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

Swi
  • Locked
  • Question
Select X of each variation of a field 1
Replies
8
Views
523
rashmibala
R
breezett93
  • Question
Query takes 30 seconds - 1 minute to process. Trying to rework it to take 5 or less
Replies
8
Views
373
breezett93
breezett93
BugZap13
  • Locked
  • Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
627
mikrom
mikrom
C
  • Locked
  • Question
Query expression negative to a 0
Replies
6
Views
428
dhookom
dhookom
JayRo71
  • Locked
  • Question
Unable to sort date field
Replies
4
Views
489
JayRo71
JayRo71

Part and Inventory Search

Sponsor

Back
Top