Splitting a Numerical String - Access 97

  • Thread starter Thread starter Jon Poste via AccessMonster.com
  • Start date Start date
J

Jon Poste via AccessMonster.com

Hi,
In my AC97 database I have a field [PropertyRef] with 10 single digits in
it. I have written a module that saves each record selected to a Word 97
file using bookmarks.

I have now been given the format of the word report and I need to split out
the [PropertyRef] field into 10 seperate bookmarks (1 digit in each) but
still maintain a single number in the database.

Could anyone assist me with this?

Cheers
Jon
 
If [PropertyRef] is a Text Field, you can use the Left, Mid and Right to
extract a single digit character out of the String.

Check Access VB Help on the above functions.
 
Thanks for your reply. I thought there was a function for it.

Regards
Jon
 
Back
Top