Format Pasting into a field - DAAUG Video on Custom Data Entry Filter Functions in MS Access


	Back to DAAUG Video 2 Comments List

Upload Images @Reply Bookmark Link Email

Format Pasting into a field

Ian O'Dett

2 years ago

I have an aceess database that I often paste text from other sources, mainly PDFs , and I other run into an issue of having the pasted results not in the format I would like. Usually, it is that the font size is too small. When this occurs I then have to change this to my desired setting. Is it possible to format the font as I paste into my field so I dont have to do this?

	Kevin Robertson @Reply 2 years ago
I would add a button to the form that pastes whatever is currently on the Clipboard then set the Font and Font Size for the field after the paste operation. Or you could set the Font and Font Size in the After Update event for the field.

	Scott Axton @Reply 2 years ago
Keep in mind that the default is "plain text". You are not going to save attributes like Bold, Colors, etc. If you change the field in the settings over to "Rich Text" you are able to paste some attributes but not always. My experience is it is some what inconsistent.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in DAAUG Video 2.