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 Chriss Miller 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
Joined
Sep 15, 2004
Messages
165
Location
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 Question
Select X of each variation of a field
Replies
8
Views
818
rashmibala
R
breezett93
  • Question Question
Query takes 30 seconds - 1 minute to process. Trying to rework it to take 5 or less
Replies
8
Views
722
breezett93
breezett93
BugZap13
  • Locked
  • Question Question
Need help creating a date from two fields to be used in where clause
Replies
5
Views
839
mikrom
mikrom
C
  • Locked
  • Question Question
Query expression negative to a 0
Replies
6
Views
702
dhookom
dhookom
mhshane
  • Question Question
Is this the best way to do this query?
Replies
9
Views
514
mhshane
mhshane

Part and Inventory Search

Sponsor

Back
Top