No Spacing between words (nospacingbetweenwords)

[DW]

I was working in my 2003 Access database and I must have accidently hit a key
and all the words in my instruction box all connected looking like the sample
below. I have tried looking up help and can't find it. Maybe this has
happened to someone before and it's a easy fix This "run-on" words copied
over to all 200+ records.


WRITE&GIVEGRAPHICINSTRUCTIONSFORTHEMAY&JUNE,TELEVISIONSPOTS.

Any help would be greatly appreciated!

Thanks,

Di

 

[AlienzDDS]

There are two possibilities that I know of. One would be an accidental
search and replace where you searched for a space and replaced with nothing.
The other possibility is corruption. I saw something similar to this once
and a compact and repair of the back and front end fixed it.

If it's the first possibility I don't think there would be a way to fix it -
you would have to go to a back up.

I hope it's the second possibility.

Ali

 

[KARL DEWEY]

I can think of another VERY remote possibility. Maybe the spaces were
replaced with a non-printing character.
One way to check is to display number of characters in the field like this --
My_Field_Lenght: Len([MyField])
Physically count the characters you see and compare with that shown by the
above.

If they are different then find what character it is like this --
My_Field_Char: Asc(Right(Left([MyField], 6), 1))
Based on you example --
WRITE&GIVEGRAPHICINSTRUCTIONSFORTHEMAY&JUNE,TELEVISIONSPOTS.

Then if the Asc is say 15 then after backing up database do Replace like
this --
Replace([MyField], Chr(15), " ")

Good luck.