By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,635 Members | 913 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,635 IT Pros & Developers. It's quick & easy.

Putting Returns back in notes fields

MattFitzgerald
P: 30
I needed to import from an old table into a new table but the tables were not exactly the same so I first exported to excel and made some alterations before pasting into the new table.

All worked fine except for my 2 notes fields which now have little square boxes where previously there were returns.

Is there any way I can do a find and replace. My problem is I do not know when doing a replace how to put the square box in the find option or a return in the replace with option.

as you can probably tell I am a lot more comfortable in Excel and just picking up access skills so:-

1st off any help to resolve would be appreciated
2ndly If any advice should be offered to avoid this in the future would be much appreciated.

Thanks in advance for any advice offered
Jan 11 '08 #1
Share this Question
Share on Google+
2 Replies


MattFitzgerald
P: 30
The probem of putting in Excel first caused more problems than I thought as cells in Excel have a smaller limit than Access Memo fields so in some instances my notes fields were incomplete.

I have however managed to resolve by importing the old table and using a unique reference field between the new and the old tables and used a make table query to replace the Notes fields in the new table with those from the old table.

Simple soloution - don't know why I did not think of it earlier.
Jan 11 '08 #2

Minion
Expert 100+
P: 108
The probem of putting in Excel first caused more problems than I thought as cells in Excel have a smaller limit than Access Memo fields so in some instances my notes fields were incomplete.

I have however managed to resolve by importing the old table and using a unique reference field between the new and the old tables and used a make table query to replace the Notes fields in the new table with those from the old table.

Simple soloution - don't know why I did not think of it earlier.

Glad you found your answer Matt. Unfortunately sometimes it's the simplest of answers that give us the most trouble.

- Minion -
Jan 11 '08 #3

Post your reply

Sign in to post your reply or Sign up for a free account.