1

Topic: Problem with Null

There is a two-dimensional array of type variant, in it  values of type null (not values = null, namely type). How with it to struggle? How it is all to translate in string for example? CStr does not work.
It was formed at data acquisition from recordset
Arr=rst. GetRows

2

Re: Problem with Null

In vba there is no type Null. There are special values Null and Empty for variables of type Variant. For operation with value Null there is function IsNull.
Concretize a question and put a file with an example.

3

Re: Problem with Null

Aster32, how it is not present? And then explain as in locals in a column type it is written variant/null?

4

Re: Problem with Null

BlackeAngel wrote:

as in locals in a column type it is written variant/null?

Aster32 wrote:

There are special values Null and Empty for variables of type Variant

5

Re: Problem with Null

Shocker. Pro, isnull does not translate in string if that.

6

Re: Problem with Null

BlackeAngel;
Sort out an array in a cycle and check through IsNull.
Plus, it is possible to try not to transform directly, and to unite:

arr (1,1) = arr (1,1) AND ""

Such focus should transform automatically value Null in a line of zero length. Though check nevertheless is better, probably. Whether Mahlo what data types in an array.

7

Re: Problem with Null

The_Prist, I already thought in this direction. It will be necessary to test good luck.

8

Re: Problem with Null

The_Prist, all turned out! Thanks!