I'm dealing with a Hospital No. in a table which follows the format that the first character is an uppercase letter and the remaining six characters have to be numbers e.g T123456, G564398, etc.
What would the validation rule look like in the table design view for this field to achieve this?
azizrasul
Last Activity: Sep 27 '07, 04:23 PM
Joined: Jun 25 '07
Location: UK
-
Validation Rule Problem
-
It didn't work, unfortunately. -
I will try that tomorrow. Just a point here, in that there will be a carriage return for each record. It's just the LAST carriage return that I'm trying to get rid of. I'll try your suggestion and see how it goes.Leave a comment:
-
Tried that, but made no difference. I don't think the Len function includes the vbCrLf in it's length evaluation.Leave a comment:
-
Removing a Carriage Return
I have a text file with x number of lines. When opening the file, I have an extra blank line which I presume is a carriage return,
How do I
1. ensure I don't have a blank line when I write to the file or
2. get rid of the extra line afterwards
Here's the code I've used for the data write: -
...Code:Private Sub Command0_Click() Dim rst As DAO.Recordset Set rst
No activity results to display
Leave a comment: